{
"iw_template_posguardado": {
"prefix": "iw_template_posguardado",
"body": [
"<?php",
"/**",
"* @file iw_template_posguardado.php",
"*",
"* Template modificador posguardado 2022.",
"*",
"* @version 4.0.0 2022-07-27 | Autor : EZ. Se creó el modificador",
"*",
"* @copyright J&B Solutions SA",
"*/",
"",
"$$tabla_principal = iw_getTabla_jbs($$id_form);",
"$$v=iw_getRegistro($$tabla_principal, $$clave);",
"",
"if($$v['x_edita'] == '1'){",
" ## Sentencias a ejecutarse al guardar parte 1",
" if($$v['estado_p1'] == 1){",
" ## Finalizada",
" $$parte=1;//\"1\"",
" $$tipo_archivo=\"\";//\"pdf\"",
" $$cond_adicional=\"AND a.name!='imagen1'\";",
" if(iw_cantidadDeAdjuntosEnRegistro_jbs($$id_form,$$clave,$$parte,$$tipo_archivo,$$cond_adicional)<=0){",
" iweb_alerts(\"warning\",\"Se debe adjuntar al menos un documento.\");",
" $$parte_siguiente=1;",
" ## Actualizamos estado de parte a pendiente",
" $$upd_setString = \"estado_p1='\".addslashes_jbs(0).\"'\";",
" $$upd_whereString = \"id='\".$$clave.\"'\";",
" if(!iw_update($$tabla_principal,$$upd_setString,$$upd_whereString)){",
" iweb_alerts(\"danger\",\"Adv.32: Problema al actualizar registro.\");",
" // echo \"<br>@debug 30 \". sql_error();",
" }",
" }else{",
" ## Avanzamos a parte 2",
" $$parte_siguiente=2;",
" $$str_mensaje=\"Se informa que guardé la parte |x_edita.\";",
" $$array_usuarios_comunicar[$$v['usr']]=$$v['usr'];",
" }",
" }else{",
" ## Pendiente - retenemos en parte 1",
" $$parte_siguiente=1;",
" }",
"}elseif($$v['x_edita'] == '2'){",
" ## Sentencias a ejecutarse al guardar parte 2",
" if($$v['estado_p2'] == 1){",
" ## Finalizada - Cerramos",
" $$parte_siguiente=3;",
" $$str_mensaje=\"Se informa que guardé la parte |x_edita.\";",
" $$array_usuarios_comunicar[$$v['usr_p2']]=$$v['usr_p2'];",
" }else{",
" ## Pendiente - retenemos en parte 2",
" $$parte_siguiente=2;",
" }",
"}",
"// echo \"<br><b>@debug</b> - variables: \".$$v['x_edita'].\" | $$tabla_principal | $$clave | $$parte_siguiente | $$cantidad_partes\";",
"if(!iw_update_parte_jbs($$tabla_principal,$$clave,$$parte_siguiente)){",
" iweb_alerts(\"danger\",\"Adv.59: Problema al actualizar registro $$clave.\");",
" // echo \"<br>@debug 57 \". sql_error();",
"}",
"if($$str_mensaje!=\"\"){",
" $$str_subject=\"Tema JB - TEST MODIFICADOR\";",
" $$bool_auditaNotas=true;",
" iw_enviar_mail_jbs($$id_form,$$v,$$clave,$$array_usuarios_comunicar,$$array_mails_comunicar,$$array_id_grupo_comunica,$$str_subject,$$str_mensaje,$$bool_auditaNotas);",
"}",
"?>"
],
"description": "iw_template_posguardado"
},
"iw_template_previsualizado": {
"prefix": "iw_template_previsualizado",
"body": [
"/**",
" * @file modificador.php",
" *",
" * Resumen de lo que hace este modificador",
" *",
" * A *description*, Este modificador es una prueba",
" * Tiene que seguir estos estandares de codificacion.",
" * Cliente J&B Solutions.",
" * Pre visualizado",
" *",
" * @version 3.9.1 2014-03-02 | Autor : XXX. Se hicieron cambios en modificador",
" * @version 3.9.2 2014-03-02 | Autor : XXX. Se hicieron cambios en modificador",
" * @version 4.0.0 2014-03-02 | Autor : XXX. Se hicieron cambios en modificador",
" * @version 4.0.1 2014-03-02 | Autor : XXX. Se hicieron cambios en modificador",
" *",
" * @copyright J&B Solutions SA",
" */",
"",
"$$select_registro = \"SELECT * FROM nombre_tabla WHERE id='$$clave'\";",
"$$res_registro = sql_query($$select_registro,$$dbi);",
"$$v = sql_fetch_array($$res_registro,$$dbi);",
"## Si es un usuario distinto del que tiene id 2 (no es jbsolutions), no puedo editar",
"if($$id_connect != '2'){",
"$$soloveo = 'S';",
"}",
"",
"##Dibujar un botón",
"echo \"<script type=\\\"text/javascript\\\">",
" $$(document).ready(function() {",
" $$( \\\"#guardar_iweb\\\" ).after('<input type=\\\"submit\\\" id=\\\"guardar_pendiente\\\" class=\\\"btn btn-primary btn-xs\\\" style=\\\"margin-top: 10px;\\\" name=\\\"add\\\" value=\\\"Pendiente de completar\\\">'); ",
" });",
" </script>\"; ",
"",
"## boorado (remove), ocultado (hide) de campos . Se usa closest tr para borrar u ocultar la fila entera ",
"echo \"<script>\";",
"echo \" $$(document).ready(function() {\";",
"echo \" $$(\\\"input[name='fields[nombre_campo]']\\\").closest('tr').remove();\";",
"echo \" $$(\\\"textarea[name='fields[nombre_campo]']\\\").closest('tr').remove();\";",
"echo \" });\";",
"echo \"</script>\";",
"",
"",
"",
"## Modificar parte anterior",
"$$cf_a['ultimo_campo_parte'].=\"<tr><td></td><td align=\\\"left\\\"><a href='\".hash_iweb_encode_url(\"$$nukeurl/modules.php?name=sgc_registracion&file=genera2®istro=$$clave&do=presentaform2&id_form=$$id_form&xmenu=$$xmenu&retro=:2:3:4\").\"'><IMG SRC=\\\"images/sgc/116.gif\\\" width=\\\"22\\\" height=\\\"15\\\" BORDER=\\\"0\\\" alt=\\\"Modificar Parte 1\\\" title=\\\"Modificar Parte 1\\\">Modificar Parte 1</a></td></tr>\" ;",
"",
"## Dibujo un campo",
"$$acceso['campo']=\"ReadOnly\"; ## Podemos indicar que el campo sea de solo lectura, o dejarlo vacío para poder escribir en él",
"$$color_campo['campo']=$$col; ## Donde $$col sería el color gris oscuro que indica que es un campo de solo lectira",
"",
"$$cf_a['campo_anterior']=\"<tr><td bgcolor=\\\"\".$$color_campo['campo'].\"\\\">Campo dibujado</td>",
"<td bgcolor=\\\"\".$$color_campo['campo'].\"\\\"><input type=\\\"text\\\" size=100\\\" \".$$acceso['campo'].\" name=\\\"campo\\\" value=\\\"\".$$v['campo'].\"\\\" ></td></tr>\";",
"",
"## preseteamos el valor de un campo 'cantidad' del formulario",
"$$vdatos['cantidad'] = 5;",
"",
"## Suponiendo que tenemos un formulario de 4 partes",
"if($$v['xbloqueado'] == \"1:2:4\" OR $$retro == \"1:2:4\"){",
"## si estor en parte 3 de un formulario, o volví a parte 3 mediante la variable retro",
"}",
"",
"## Realizar cálculos online, según valores que se van ingresando en el momento.",
"## Esta validación no es encesaria para la nueva versión.",
"## IMPORTANTE: Debe estar la carpeta includes/jquery/jquery.min.js en el site del cliente",
"if($$constante_url_site_cloud==\"\"){",
"echo \"<script type=\\\"text/javascript\\\" src=\\\"./includes/JQuery/jquery.min.js\\\"></script>\\n\";",
"}",
"",
"##Mostrar un mensaje utilizando Jquery",
"echo \" <script>",
" $$( document ).ready(function() {",
" alert(\\\"Probando Jquery\\\");",
" });",
" </script>\";",
"",
"",
"## HACER calculos en tiempo real y ponerlo en un campo de iweb (autocalculado)",
"echo \"<script>",
"$$( document ).ready(function() {",
" ",
"// Tomo valor de un campo de primera parte",
"var tiraje_ped = parseInt($$( \\\"input[name='fields[tiraje_ped]']\\\" ).val());",
"if(!$$.isNumeric(tiraje_ped)){",
"tiraje_ped =0;",
"}",
"",
"// Seteo class para que si alguno de estos elementos cambia que autocalcule el total nuevamente",
"$$( \\\"input[name='fields[bncls_compl]']\\\" ).addClass( \\\"accion_total\\\" );",
"$$( \\\"input[name='fields[cant_bncl]']\\\" ).addClass( \\\"accion_total\\\" );",
"",
"// Se puede setear a un elemento por el nombre un id para poder manejarlo más fácil con jquery",
"//$$( \\\"input[name='fields[bncls_compl]']\\\" ).attr('id', 'bncls_compl');",
"",
"// Con el blur capturo el evento de cambio en algunos de los elementos que tiene la clase accion_total",
"$$('.accion_total').blur(function () {",
"",
"var bncls_compl = parseInt($$( \\\"input[name='fields[bncls_compl]']\\\" ).val());",
"var cant_bncl = parseInt($$( \\\"input[name='fields[cant_bncl]']\\\" ).val());",
"",
"",
"if(!$$.isNumeric(bncls_compl)){",
"bncls_compl =0;",
"}",
"if(!$$.isNumeric(cant_bncl)){",
"cant_bncl =0;",
"}",
" ",
"tot = (bncls_compl * cant_bncl) + bncl_ext1 + bncl_ext2 + especiales + demasia;",
"",
"if(tot >= tiraje_ped){",
"//verde",
"$$( \\\"#tr_total_calculado_js\\\" ).attr('bgcolor', '#92D050');",
"}else{",
"//rojo",
"$$( \\\"#tr_total_calculado_js\\\" ).attr('bgcolor', '#FF0000');",
"}",
"",
"$$( \\\"#td_total_calculado_js\\\" ).html(\\\"<b><big>\\\"+tot+\\\"</big></b>\\\");",
"",
"});",
"",
"});",
"</script>\";",
"",
"### deshabilitar el botón guardar ",
"echo \"",
" <script>",
" $$( document ).ready(function() { ",
" ",
" $$(\\\"textarea[name='fields[accion_inmediata]']\\\").addClass('proveedor');",
" $$(\\\"textarea[name='fields[analisis_de_causa]']\\\").addClass('proveedor');",
" $$(\\\"textarea[name='fields[obs_accion_correctiva]']\\\").addClass('proveedor');",
" $$( \\\"input[name='rad41']\\\" ).addClass('proveedor'); ",
" ",
" // PONGO LA LEYENDA DE QUE NO SE PUEDE GUARDAR EL REGISTRO ",
" $$('#guardar_iweb').parent().parent().parent('<tr id=\\\"save_disabled\\\" class=\\\"sgc_parteXXXXXXXXXXX\\\"><td colspan=\\\"2\\\"><font color=red>   Para poder cerrar la parte por favor complete todos los campos. </font></td></tr>'); ",
" ",
" $$(\\\".proveedor\\\").on('change keyup paste mouseup', function() { ",
" if( $$( \\\"input[name='rad41']:checked\\\" ).val() == '1' ){",
" if( $$(\\\"textarea[name='fields[accion_inmediata]']\\\").val() == '' || $$(\\\"textarea[name='fields[analisis_de_causa]']\\\").val() == '' || $$(\\\"textarea[name='fields[obs_accion_correctiva]']\\\").val()== '' ) {",
" $$('#guardar_iweb').prop('disabled', true); //Deshabilito el submit ",
" $$('#guardar_iweb_final').prop('disabled', true); //Deshabilito el submit ",
" $$('#save_disabled').show(); //Muestro advertencia de completar campos obligatorios",
" }else{",
" if($$(\\\"textarea[name='fields[accion_inmediata]']\\\").val() != '' && $$(\\\"textarea[name='fields[analisis_de_causa]']\\\").val() != '' && $$(\\\"textarea[name='fields[obs_accion_correctiva]']\\\").val()!= ''){",
" $$('#guardar_iweb_final').prop('disabled', false); //Habilito el submit",
" $$('#guardar_iweb').prop('disabled', false);",
" $$('#save_disabled').hide();",
" }",
" } ",
" }else{",
" if( $$( \\\"input[name='rad41']:checked\\\" ).val() == '0' ){ ",
" $$('#guardar_iweb_final').prop('disabled', false); //Habilito el submit si esta Pendiente",
" $$('#guardar_iweb').prop('disabled', false);",
" $$('#save_disabled').hide();",
" }",
" }",
" ",
" });",
" ",
" }); ",
" </script>\"; ",
"",
"",
"## Otras aplicaciones:",
"",
"## Para hacer referencia a un campo:",
"## $$(\\\"textarea[name='fields[campo]']\\\")",
"## luego se le puede aplicar una función, como: .attr()...",
"## \"textarea\" puede ser reemplazado por \"input\", \"a\" o el tag que corresponda al campo al que se quiere hacer referencia.",
"## \"name\" es el atributo con el cual vamos a distinguir al campo en particular",
"## \"fields['campo']\" es el valor de dicho atributo",
"",
"",
"",
"## Ocultar botón de acciones",
"echo \"<script>\";",
"echo \" $$(document).ready(function() {\";",
"echo \" $$(\\\".btn-group\\\").hide();\";",
"echo \" });\";",
"echo \"</script>\";",
"",
"## Ocultar botones al pie del formulario",
"echo \"<script>\";",
"echo \" $$(document).ready(function() {\";",
"echo \" $$( \\\"a[role='button']\\\" ).hide();\";",
"echo \" });\";",
"echo \"</script>\";",
"",
"## Tamaño de los campos texto",
"if((!isset($$retro) AND $$v['xbloqueado'] == '1:3:4:5:6:7') OR $$retro == '1:3:4:5:6:7'){ ## Parte 2",
"## Cuando la parte en la que se encuentra el campo al que le queremos definir el tamaño está activa (altura de 6 renglones)",
"echo \"<script>",
"$$(document).ready(function(){",
"$$( \\\"textarea[name='fields[campo]']\\\" ).attr('rows','6');",
"});",
" </script>\";",
"} else {",
"## Cuando la parte en la que se encuentra el campo al que le queremos definir el tamaño está inactiva",
"## Si la altura es mayor a 20 renglones, mostramos solo 20 (es resto se ve scrolleando)",
"echo \"<script>",
"$$(document).ready(function(){",
"var filas = $$( \\\"textarea[name='fields[campo]']\\\" ).attr('rows');",
"if(filas > 20){",
"$$( \\\"textarea[name='fields[campo]']\\\" ).attr('rows','20');",
"}",
"});",
" </script>\";",
"}",
"## Ocultar muñequitos de accesos a cada parte",
"echo \"<script>\";",
"echo \" $$(document).ready(function() {\";",
"echo \" $$(\\\".sgc_header_partes_info2\\\").hide();\";",
"echo \" });\";",
"echo \"</script>\";",
"##Ocultado de campos mediante radio button",
"echo \" <script>",
" $$( document ).ready(function() {",
" /// Esto para detectar radio bottom cuando cambia de valor ",
" var campo_radio = $$( \\\"input[name='fields[campo_radio]']\\\" ).val();",
" //Selección de valor ",
" $$( \\\"input[type=radio][name='\\\"+campo_radio+\\\"']\\\" ).change(function() {",
" ",
" if(this.value == 0){",
" //Opcion 0",
" $$( \\\"input[name='campoTexto']\\\" ).closest('tr').show();",
" $$( \\\"textarea[name='campoTextoExtendido']\\\" ).closest('tr').hide();",
" }else if(this.value == 1){",
" //Opcion 1",
" $$( \\\"input[name='campoTexto ']\\\" ).closest('tr').show();",
" $$( \\\"input[name='campo2']\\\" ).closest('tr').hide();",
" }else if(this.value == 2){",
" //Opcion 2",
" $$( \\\"input[name='campo1']\\\" ).closest('tr').show();",
" $$( \\\"input[name='campo2']\\\" ).closest('tr').hide();//Cambiar estado del radio",
" //Tildar un radio",
" $$( \\\"input:radio[name='campoRadio'][value='0']\\\" ).prop('checked', true);",
" }",
" });",
" } ",
" </script> ",
"\";",
"",
"",
"##Ejemplo de dibujar un link (botón), y luego preguntar por su valor para realizar consultas sobre formulario:",
"$$cf_a['nombre_del_campo_anterior_a_este_link'].= \"<tr><td colspan=\\\"2\\\"><A HREF=\\\"$$nukeurl/modules.php?name=sgc_registracion&file=genera2®istro=$$clave&do=presentaform2&id_form=$$id_form&xmenu=$$xmenu&bloquea=\".$$v['xbloqueado'].\"&pausar=0\\\"><big> Etiqueta del link, en este caso con pausar=0 $$clave</big></A></td></tr>\" ;",
"if($$pausar == \"0\"){",
" ##Si pausar es igual a cero, ejecutamos código dentro de este if",
" ##Observar que en la definición del link, se pueden enviar varias variables, como por ejemplo el xbloqueado propio del formulario ",
" echo \"<body onLoad=\\\"document.location='modules.php?name=sgc_registracion&file=genera2®istro=$$clave&do=presentaform2&id_form=$$id_form&xmenu=$$xmenu'\\\">\\n\";",
"}",
"",
"",
"## Cómo hacer referencia a un formulario padre desde un formulario hijo (iframes)",
"echo \"<script>",
"$$(document).ready(function(){",
"$$('iframe[name=select_frame]').contents().find('#select_name').val();",
"});",
"</script>\";",
"## Cómo hacer referencia desde un formulario hijo a un campo de un formulario padre (iframes)",
"echo \"<script>",
"$$(document).ready(function(){",
"$$('#id', window.parent.document).html('write something');",
"});",
"</script>\";",
"",
"",
"## Verifico que estas instrucciones se ejecuten solo cuando trabajo con el formulario como hijo de otro",
"if($$vmh == 'sgc_registracion-genera_hijo'){",
"$$no_veo_clonacion = \"S\";",
"$$no_veo_edita_en_linea = \"S\";",
"$$no_veo_edita_en_formulario = \"S\";",
"",
"## los registros que quiero ver",
"$$veo_registros_filtrados = \" AND a.estado = '0'\";",
"",
"## el orden en que quiero ver los registros hijos",
"$$veo_orden = \" ORDER BY a.fecha_fin ASC \";",
"########################################################################################################",
"## ESTA OPCION ES PARA PODER AGREGAR UN BOTON GUARDAR AL FINAL DEL MULTIREGISTRO y que solo recargue esa parte y poder poner INPUT editables en cada hijo",
"//echo \"</form><form name=\\\"addatri\\\" method=\\\"post\\\" enctype=\\\"multipart/form-data\\\" action=\\\"\".hash_iweb_encode_url(\"modules.php?name=sgc_registracion&file=genera_hijo\").\"\\\">\";",
"",
"## armo un vector generando input text para que la persona pueda editar en linea cada campo del multiregistro",
"while($$v = sql_fetch_array($$res_registro,$$dbi)){",
"$$readOnly = \"\";",
"$$campo_descuento = \"descuento_\".$$id;",
"if($$v['descuento'] != \"\"){",
"$$valor_descuento = $$v['descuento'];",
"} else {",
"$$valor_descuento = $$$$campo_descuento;",
"}",
"if($$v_padre['xbloqueado'] != '1:3'){",
" $$readOnly = \"readonly\";",
"}",
"$$vec_columna['precio_total'][$$v['id']] = \"<td nowrap><div class=\\\"form-inline\\\"><input type=\\\"text\\\" name=\\\"$$campo_descuento\\\" value=\\\"\".$$valor_descuento.\"\\\" class=\\\"form-control input-sm \\\" size=\\\"5\\\" $$readOnly></td>\";",
"}",
"## Deshabilito el botón para guardar multi, para que no guarde el descuento con enter.",
"echo \"<script>",
"$$(document).ready(function(){",
"$$(\\\"#guardar_iweb_multi\\\").attr(\\\"disabled\\\",true);",
"});",
"</script>\";",
"## Oculto Agregar nuevo registro y agrego el boton descuento ",
"$$boton_descuento = \"</tbody><tr><td colspan = \\\"14\\\"><table width = \\\"100%\\\"><tr><td colspan = \\\"14\\\"><input type=\\\"submit\\\" name=\\\"guardar_descuento\\\" value=\\\"Guardar sólo descuentos\\\" class=\\\"btn btn-primary btn-xs\\\"></td></tr>\";",
"echo \"<script>",
"$$(document).ready(function(){",
"$$(\\\"table[id='table_iframeitems_aprobar']\\\").append('<br>$$boton_descuento');",
"$$(\\\"tr[id='trNuevoRegistro']\\\").hide();",
"})",
"</script>\";",
"",
"## ESTE CODIGO ES donde se guardan los input text generados. Este codigo va tambien en el previsualizado.",
"if(isset($$guardar_descuento)){",
"$$select_registros = \"SELECT id,precio_unitario,cantidad FROM a0usr_vi_registro_oport_det WHERE xid_padre = '$$xid_padre'\";",
"$$res_registros = sql_query($$select_registros,$$dbi);",
"",
"while(list($$id,$$precio_unitario,$$cantidad) = sql_fetch_row($$res_registros,$$dbi)){",
"$$campo_descuento = \"descuento_\".$$id;",
"$$precio_total = $$precio_unitario * $$cantidad;",
"$$campo_total = $$precio_total * (1 - ($$$$campo_descuento / 100));",
"$$update_descuento = \"UPDATE a0usr_vi_registro_oport_det SET descuento = '\".$$$$campo_descuento.\"', total_descuento = '$$campo_total' WHERE id = '$$id'\";",
"// echo \"<b>@debug</b> - update_descuento: $$update_descuento<br>\";",
"if(!sql_query($$update_descuento,$$dbi)){",
"iweb_alerts(\"danger\",\"¡Problema al guardar descuento para registro de insumo nro. $$id!\");",
"}",
"}",
"",
"}",
"",
"##################################################################################################################################",
"",
"## armo un vector con los ids de los registros que el $$id_connect tiene permitido borrar",
"while($$v = sql_fetch_array($$res_registro,$$dbi)){",
"if($$id_connect == $$v['xuser_connect']){",
"$$vec_borra[$$v['id']] = $$v['id'];",
"}",
"}",
"## seteo un valor al vector para el caso en que no pueda borrar ningún registro",
"if(!isset($$vec_borra)){",
"$$vec_borra[0] = 0;",
"}",
"",
"## armo un vector con los ids de los registros que se pueden editar",
"$$res = sql_query($$sql,$$dbi);",
"while($$v = sql_fetch_array($$res_registro,$$dbi)){",
"if($$id_connect == $$v['xuser_connect']){",
"$$vec_edita[$$v['id']] = $$v['id'];",
"}",
"}",
"## seteo un valor al vector para el caso en que no pueda editar ningún registro",
"if(!isset($$vec_edita)){",
"$$vec_edita[0] = 0;",
"}",
"",
"## Agrego una columna después de un campo cualquiera",
"## donde campo es el campo que se ubica a la izquierda de la columna a agregar",
"## No olvidar poner los tag para crear las columnas: <td></td>",
"## Se puede agregar más de una columna ya que se pueden agregar con los tag <td></td> que sean necesarios",
"$$titulo_columna['campo'] = \"<td align = \\\"center\\\"><b>Título nueva columna</b></td>\";",
"$$vec_columna['campo'][$$v['id']] = \"<td align = \\\"center\\\">Contenido nueva columna</td>\";",
"}",
"",
"##Bloqueo de campos, SI NO TENGO acceso a la siguiente parte, pero tengo el grupo funcional anterior, que no me deje editar ",
"$$sql_partes_cierre = \"SELECT gr_ingre, bloquea,parte FROM \".$$prefix.\"_sgc_formularios_def",
"WHERE id_form=$$id_form AND tipo='accion'\";",
"// echo \"$$sql_partes_cierre\";",
"$$res_partes_cierre = sql_query($$sql_partes_cierre, $$dbi);",
"while ($$def_accesos_form = sql_fetch_array ($$res_partes_cierre, $$rdbi)) {",
" $$vec_acceso_partes[$$def_accesos_form['parte']]=$$def_accesos_form['gr_ingre'];",
" $$vec_xbloqueado_partes[$$def_accesos_form['bloquea']]=$$def_accesos_form['parte']+1;",
"} ",
"if (!in_array($$vec_acceso_partes[$$vec_xbloqueado_partes[$$v['xbloqueado']]],$$lisfun) AND $$vmh != \"sgc_registracion-genera1\"){",
" $$soloveo=\"S\";",
"// echo \"<br />Parte Activa \".$$vec_xbloqueado_partes[$$v['xbloqueado']];",
"// echo \"<br />Grupo funcional de la parte Activa \".$$vec_acceso_partes[$$vec_xbloqueado_partes[$$v['xbloqueado']]];",
"}",
"",
"",
"",
"",
"### Javascript para poder pre cargar la accion de un lov",
"if($$vmh==\"sgc_registracion-genera1\" OR isset($$retro)){",
"",
"//lista_lov : [0] tabla [1] vincula id=id_busca [2] Nada [3] campo que devuelve el select",
"// EJEMPLO de inner join como data: \\\"lista_lov=a0usr_al_tm_proveedores as a INNER JOIN nuke_users as b ON a.usuario_iweb=b.uid:a.id::uname&id_busca=\\\" + pref0,",
"",
" $$javascrip_lov_custom = \"",
"/// Pongo el spinner ",
"$$(\\\"#unamefields_usr_sistema_int\\\").closest('div').prepend(\\\"<img src='$$constante_url_site_cloud/includes/JQuery_plugins/jqueryui/images/ui-anim_basic_16x16.gif' id='spinner_iweb' style='display:none;' >\\\");",
"$$('#spinner_iweb').show(); ",
"",
"/// BUSCO EL UID del usuario responsable del area",
" $$.ajax({ ",
" type: \\\"get\\\", ",
" url: \\\"\".hash_iweb_encode_url(\"$$nukeurl/modules.php?name=files_mod_registracion&file=ajax_upd_det_montos\").\"\\\",",
" data: \\\"lista_lov=nuke_users:uid::uid&id_busca=\\\" + pref0, ",
" success:function(data){",
" $$(\\\"#fields_usr_sistema_int\\\").val(data);",
" }, ",
" error: function(){",
" alert('Problema al pre cargar el responsable. Por favor vuelva a seleccionar el area.');",
" } ",
" });",
" /// BUSCO EL codigo del usuario responsable del area ",
" $$.ajax({ ",
" type: \\\"get\\\", ",
" url: \\\"\".hash_iweb_encode_url(\"modules.php?name=sgc_xmuestra&file=ajax_retorna_valor_table\").\"\\\",",
" data: \\\"lista_lov=nuke_users:uid::uname&id_busca=\\\" + pref0, ",
" success:function(data){",
" $$(\\\"#unamefields_usr_sistema_int\\\").val(data);",
" }, ",
" error: function(){",
" alert('Problema al pre cargar el responsable. Por favor vuelva a seleccionar el area.');",
" } ",
" });",
" /// BUSCO la descripción del usuario responsable del area ",
"$$.ajax({ ",
" type: \\\"get\\\", ",
" url: \\\"\".hash_iweb_encode_url(\"modules.php?name=sgc_xmuestra&file=ajax_retorna_valor_table\").\"\\\",",
" data: \\\"lista_lov=nuke_users:uid::name&id_busca=\\\" + pref0, ",
" success:function(data){",
" $$(\\\"#namefields_usr_sistema_int\\\").val(data);",
" }, ",
" error: function(){",
" alert('Problema al pre cargar el responsable. Por favor vuelva a seleccionar el area.');",
" } ",
" });",
" // Una vez que terminan todos los llamados de ajax ahi oculto el spinner ",
" $$( document ).ajaxStop(function() {",
"$$('#spinner_iweb').hide();",
"});",
" ",
" \"; ",
" ## aca sobreescribimos la funcion cuando se hace click en el lov. Este codigo debe ponerse despues del campo lov a recargar",
" // la funcion ponPrefijoXXXXXXaddatri(). No olvidar de cambiar los nombres de campos en document.addatri.xxxxxxx.value=pref0 , 1 , 2 ",
" $$cf_a['usr_sistema'].= \"",
" <script>",
" function ponPrefijofields_usr_sistemaaddatri(pref0,pref1,pref2){",
"pref0= pref0.replace(/____\\|____/g,'\\\\n');",
"pref1=pref1.replace(/____\\|____/g,'\\\\n');",
"pref2=pref2.replace(/____\\|____/g,'\\\\n');",
" document.addatri.fields_usr_sistema.value=pref0;",
"document.addatri.unamefields_usr_sistema.value=pref1;",
"document.addatri.namefields_usr_sistema.value=pref2;",
"$$('#iweb_modal_fields_usr_sistemaaddatri').modal('hide');",
"//console.log('hola redefinida la funcion del lov');",
"$$javascrip_lov_custom",
" } ",
" </script>",
" \";",
"}"
],
"description": "iw_template_previsualizado"
},
"iw_template_prebuscado": {
"prefix": "iw_template_prebuscado",
"body": [
"/**",
" * @file modificador.php",
" *",
" * Resumen de lo que hace este modificador",
" *",
" * A *description*, Este modificador es una prueba",
" * Tiene que seguir estos estandares de codificacion.",
" * Cliente J&B Solutions.",
" * Pre buscado",
" *",
" * @version 3.9.1 2014-03-02 | Autor : XXX. Se hicieron cambios en modificador",
" * @version 3.9.2 2014-03-02 | Autor : XXX. Se hicieron cambios en modificador",
" * @version 4.0.0 2014-03-02 | Autor : XXX. Se hicieron cambios en modificador",
" * @version 4.0.1 2014-03-02 | Autor : XXX. Se hicieron cambios en modificador",
" *",
" * @copyright J&B Solutions SA",
" */",
"",
"##Variable para definir si se ve o no el SQL que ejecuta genera",
"$$sql_debug_pb = \"S\";",
"// if(isset($$horas_conectado)){",
"// $$def_wher_pre_buscar=\" AND $$id_connect=b.usuario \";",
"// ",
"// }",
"## Esta consulta permite filtrar los registros a mostrar, y a su vez, modificar el cuadro resumen de cantidad de registros encontrados.",
"$$def_wher_pre_buscar=\" AND (a.confidencialidad = 1 ",
"OR EXISTS (SELECT 1 FROM unp_she_usuarios_acciones as b WHERE confidencialidad = 1 AND $$id_connect=b.usuario)",
")\";",
"",
"## Esto permite modificar el tablero resumen de registros por parte. Con Jqery se puede sacar el tablero resumen o poner algun html antes de buscar. ",
"## Se podrían ocultar inputs para la busqueda",
"if($$do==\"presentaform\"){",
" echo \"<script type=\\\"text/javascript\\\">\";",
" echo \"$$(document).ready(function() {\";",
" echo \" ",
" $$(\\\"#sgc_header-tablero_resumen\\\").append(' <b><p class=\\\"text-danger\\\" style=\\\"display:inline;\\\">de sus tickets de su/s cuenta/s</p> que tiene asignada/s </b>');",
" \";",
" echo \" });\"; ",
" echo \"</script>\";",
"}"
],
"description": "iw_template_prebuscado"
},
"iw_template_preguardado": {
"prefix": "iw_template_preguardado",
"body": [
"/**",
" * @file modificador.php",
" *",
" * Resumen de lo que hace este modificador",
" *",
" * A *description*, Este modificador es una prueba",
" * Tiene que seguir estos estandares de codificacion.",
" * Cliente J&B Solutions.",
" * Pre Guardado",
" *",
" * @version 3.9.1 2014-03-02 | Autor : XXX. Se hicieron cambios en modificador",
" * @version 3.9.2 2014-03-02 | Autor : XXX. Se hicieron cambios en modificador",
" * @version 4.0.0 2014-03-02 | Autor : XXX. Se hicieron cambios en modificador",
" * @version 4.0.1 2014-03-02 | Autor : XXX. Se hicieron cambios en modificador",
" *",
" * @copyright J&B Solutions SA",
" */",
"",
"",
"",
"## Comprueba que no haya otro equipo con el mismo numero de serie y modelo",
"$$mensaje_p=\"\";",
"$$select_equipos = \"SELECT 1 FROM i1_crm_service_tm_equipos",
" WHERE nro_serie='\".$$fields['nro_serie'].\"'",
" AND modelo='\".$$fields['modelo'].\"' AND id !='$$clave'\";",
"$$res_equipos = sql_query($$select_equipos,$$dbi);",
"",
"$$nrows_equipos=0;",
"$$nrows_equipos=sql_num_rows($$res_equipos, $$dbi);",
"if ($$nrows_equipos>0){",
"$$mensaje_p.=\"<b>-El equipo con Nro de serie : \".$$fields['nro_serie'].\"",
" y Modelo: \".$$fields['modelo'].\" ya está ingresado en el sistema</b>\";",
"}",
"if($$mensaje_p!=\"\"){",
"$$bgcolor2 = \"#A2B3CB\";",
"$$bgcolor3 = \"#E7E7E7\";",
"$$bgcolor4 = \"#AAAAAA\";",
"$$textcolor1 = \"#555555\";",
"$$textcolor2 = \"#000000\";",
"echo \"<table width=\\\"100%\\\" border=\\\"0\\\" cellspacing=\\\"1\\\" cellpadding=\\\"0\\\" bgcolor=\\\"$$bgcolor2\\\"><tr><td>\\n\";",
"echo \"<table width=\\\"100%\\\" border=\\\"0\\\" cellspacing=\\\"1\\\" cellpadding=\\\"4\\\" bgcolor=\\\"$$bgcolor1\\\"><tr><td>\\n\";",
"die(\"<tr><td><IMG SRC=\\\"images/crm/stop.gif\\\" BORDER=\\\"0\\\"><b>$$mensaje_p!<br /><br><br /><br /></b><a href=\\\"javascript:history.go(-1)\\\">Volver hacia atrás</a></td></tr>",
"</td></tr></table></td></tr></table>\\n\");",
"}",
"",
"",
"$$hoy=date('Y-m-d');",
"$$ahora=date('Y-m-d H:i:s');",
"",
"",
"$$se_aprobo=\"\";",
"",
"function auditarFechayUsuario($$campo_fecha,$$campo_usuario){",
" global $$clave,$$dbi,$$id_connect,$$hoy;",
" $$upd_audita_userfecha=\"UPDATE a0usr_a_validacion_claim_v4 SET $$campo_fecha='$$hoy',$$campo_usuario='$$id_connect' WHERE id='$$clave'\";",
"// echo \"<br />@debug Audita Usuario y fecha en campo parte 2: $$upd_audita_userfecha\";",
" if (!sql_query($$upd_audita_userfecha,$$dbi)==1){",
" echo \"<IMG SRC=\\\"images/sgc/stop.gif\\\" BORDER=\\\"0\\\"><br><b>Error al auditar usuario y fecha que intervino</b><br>\"; ",
" } ",
"} ",
"",
"if (strcasecmp($$v['xbloqueado'],\"1:3:4\")==\"0\"){",
" title(\"Información sobre la Evaluación de Claims Health o Marca (Marketing, Legales, Regulatorio y Desarrollo)\");",
" $$radio1=$$fields['apb_mkt'];",
" $$radio2=$$fields['apb_legal'];",
" $$radio3=$$fields['apb_regula'];",
" $$radio4=$$fields['apb_desarrollo'];",
"// echo \"<br />@debug <big> X_EDITA = 2 </big>\";",
"// echo \"<br />@debug ID USUARIO $$id_connect\";",
"// echo \"<br />@debug FECHA $$hoy\";",
"// echo \"<br />@debug Marketing Antes--> \".$$v['apb_mkt'];",
"// echo \"<br />@debug Despues--> \".$$$$radio1;",
"// echo \"<br />@debug Legales Antes--> \".$$v['apb_legal'];",
"// echo \"<br />@debug Despues--> \".$$$$radio2;",
"// echo \"<br />@debug Regulatorio Antes--> \".$$v['apb_regula'];",
"// echo \"<br />@debug Despues--> \".$$$$radio3;",
"// echo \"<br />@debug Desarroollo Antes--> \".$$v['apb_desarrollo'];",
"// echo \"<br />@debug Despues--> \".$$$$radio4; ",
" ",
" if (($$$$radio1!=$$v['apb_mkt']and $$$$radio1!=\"\") or $$fields['comenta_mkt']!=$$v['comenta_mkt']){",
" //echo \"<br />@debug<big><b> ACTUALIZO INFORMACION Marketing </big></b><br>\";",
" $$se_aprobo=\"apb_mkt\";",
" auditarFechayUsuario(\"fec_apb_mkt\",\"usu_apb_mkt\");",
" }",
" if(($$$$radio2!=$$v['apb_legal'] and $$$$radio2!=\"\") or $$fields['comenta_legal']!=$$v['comenta_legal']){",
" //echo \"<br />@debug<big><b> ACTUALIZO INFORMACION Legales </big></b><br>\";",
" $$se_aprobo=\"apb_legal\";",
" auditarFechayUsuario(\"fec_apb_legal\",\"usu_apb_legal\");",
" }",
" if(($$$$radio3!=$$v['apb_regula'] and $$$$radio3!=\"\") or $$fields['comenta_regula']!=$$v['comenta_regula']){",
" //echo \"<br />@debug<big><b> ACTUALIZO INFORMACION Regulatorio </big></b><br>\";",
" $$se_aprobo=\"apb_regula\";",
" auditarFechayUsuario(\"fec_apb_regula\",\"usu_apb_regula\");",
" }",
" if(($$$$radio4!=$$v['apb_desarrollo'] and $$$$radio4!=\"\") or $$fields['comenta_desarrollo']!=$$v['comenta_desarrollo']){",
" //echo \"<br />@debug<big><b> ACTUALIZO INFORMACION Desarrollo </big></b><br>\";",
" $$se_aprobo=\"apb_desarrollo\";",
" auditarFechayUsuario(\"fec_apb_desarrollo\",\"usu_apb_desa\");",
" }",
"",
"}elseif(strcasecmp($$v['xbloqueado'],\"1:2:4\")==\"0\"){",
" title(\"Información sobre la Evaluación de Claims Nature (Medio Ambiente, Relaciones Institucionales y Marketing)\");",
" $$radio1=$$fields['apb_medam'];",
" $$radio2=$$fields['apb_relinst'];",
" $$radio3=$$fields['apb_mkt_n'];",
"// echo \"<br />@debug <big> X_EDITA = 3 </big>\";",
"// echo \"<br />@debug ID USUARIO $$id_connect\";",
"// echo \"<br />@debug FECHA $$hoy\";",
"// echo \"<br />@debug Medio AMbiente Antes--> \".$$v['apb_mkt'];",
"// echo \"<br />@debug Despues--> \".$$$$radio1;",
"// echo \"<br />@debug Relaciones Institucionales Antes--> \".$$v['apb_legal'];",
"// echo \"<br />@debug Despues--> \".$$$$radio2;",
"// echo \"<br />@debug Marketing Antes--> \".$$v['apb_mkt_n'];",
"// echo \"<br />@debug Despues--> \".$$$$radio3;",
" ",
" if (($$$$radio1!=$$v['apb_medam']and $$$$radio1!=\"\") or $$fields['comenta_medam']!=$$v['comenta_medam']){",
" //echo \"<br />@debug<big><b> ACTUALIZO INFORMACION Medio Ambiente </big></b><br>\";",
" $$se_aprobo=\"apb_medam\";",
" auditarFechayUsuario(\"fec_apb_medam\",\"usu_apb_medam\");",
" }",
" if(($$$$radio2!=$$v['apb_relinst'] and $$$$radio2!=\"\") or $$fields['comenta_relinst']!=$$v['comenta_relinst']){",
" //echo \"<br />@debug<big><b> ACTUALIZO INFORMACION Relaciones Institucionales </big></b><br>\";",
" $$se_aprobo=\"apb_relinst\";",
" auditarFechayUsuario(\"fec_apb_relinst\",\"usu_apb_relinst\");",
" }",
" if(($$$$radio3!=$$v['apb_mkt_n'] and $$$$radio3!=\"\") or $$fields['comenta_mkt_n']!=$$v['comenta_mkt_n']){",
" //echo \"<br />@debug<big><b> ACTUALIZO INFORMACION Marketing </big></b><br>\";",
" $$se_aprobo=\"apb_mkt_n\";",
" auditarFechayUsuario(\"fec_apb_mkt_n\",\"usu_apb_mkt_n\");",
" }",
"}"
],
"description": "iw_template_preguardado"
},
"iw_template_preborrado": {
"prefix": "iw_template_preborrado",
"body": [
"/**",
" * @file modificador.php",
" *",
" * Resumen de lo que hace este modificador",
" *",
" * A *description*, Este modificador es una prueba",
" * Tiene que seguir estos estandares de codificacion.",
" * Cliente J&B Solutions.",
" * Pre borrado",
" *",
" * @version 3.9.1 2014-03-02 | Autor : XXX. Se hicieron cambios en modificador",
" * @version 3.9.2 2014-03-02 | Autor : XXX. Se hicieron cambios en modificador",
" * @version 4.0.0 2014-03-02 | Autor : XXX. Se hicieron cambios en modificador",
" * @version 4.0.1 2014-03-02 | Autor : XXX. Se hicieron cambios en modificador",
" *",
" * @copyright J&B Solutions SA",
" */",
"",
"",
"",
"if($$vmh=='sgc_registracion-genera_hijo'){",
"// echo \"<b> rc es el id del registro cuando se quiere volver a cargar \".$$rc;",
"// echo \"<br>b_item es el id del registro cuando se quiere borrar \".$$b_item;",
" if($$b_item){",
" $$registro = $$b_item;",
" } else {",
"$$registro = $$rc;",
" }",
"}",
"",
"$$sql = \"SELECT * FROM tabla WHERE id='$$registro'\";",
"$$res = sql_query($$sql,$$dbi);",
"$$v = sql_fetch_array($$res,$$dbi);",
"",
"## inserto auditoría",
"$$insert_auditoria = \"INSERT INTO tabla_auditoria (id,detalle) VALUES ('','Se borró el regisrto $$registro')\";",
"if(!sql_query($$insert_auditoria,$$dbi)==1){",
" echo \"<IMG SRC=\\\"images/sgc/stop.gif\\\" BORDER=\\\"0\\\"> <b>Error al insertat auditoría!</b><br>\";",
"}"
],
"description": "iw_template_preborrado"
},
"iw_template_posguardadonotas": {
"prefix": "iw_template_posguardadonotas",
"body": [
"/**",
" * @file modificador.php",
" *",
" * Resumen de lo que hace este modificador",
" *",
" * A *description*, Este modificador es una prueba",
" * Tiene que seguir estos estandares de codificacion.",
" * Cliente J&B Solutions.",
" * Pos guardado Notas",
" *",
" * @version 3.9.1 2014-03-02 | Autor : XXX. Se hicieron cambios en modificador",
" * @version 3.9.2 2014-03-02 | Autor : XXX. Se hicieron cambios en modificador",
" * @version 4.0.0 2014-03-02 | Autor : XXX. Se hicieron cambios en modificador",
" * @version 4.0.1 2014-03-02 | Autor : XXX. Se hicieron cambios en modificador",
" *",
" * @copyright J&B Solutions SA",
" */",
"",
"",
"$$select_registro=\"SELECT * FROM a0usr_form_acc_tarea WHERE id='$$clave'\";",
"$$res_registro = sql_query($$select_registro, $$dbi);",
"$$v = sql_fetch_array($$res_registro, $$dbi);",
"",
"## Invertimos el órden del campo notas ",
"## Tomamos la ultima nota ingresada:",
"$$notas_aux0=$$v['xcoment_anexo'];",
"$$notas_aux2=$$notas_aux0;",
"$$pos_ini_ultima_nota=\"\";",
"$$i=0;",
"do{",
"$$notas_aux1=substr($$notas_aux0, strripos($$notas_aux2, \"#### \"));",
"if($$i==0){",
"$$fec_hora_aux1=substr($$notas_aux0, strripos($$notas_aux2, \"#### \")+5, 20);",
"}",
"// echo \"@debug fec_hora_aux1: $$fec_hora_aux1<br />\";",
"// echo \"@debug notas_aux2: $$notas_aux2<br />\";",
"// echo \"@debug comentario cortado 1 (notas aux 1): $$notas_aux1<br />\";",
"// echo \"@debug substr: \".substr($$notas_aux1,0,15).\"<br />\";",
"// echo \"@debug pos: \".strripos($$notas_aux2, \"#### \").\"<br />\";",
"// echo \"@debug 1: \".substr($$notas_aux1,26,45).\"<br />\";",
"// echo \"@debug 2: \".stripos(substr($$notas_aux1,26,45), \"envio mail a\", 0).\"<br />\";",
"if(preg_match('/^#### \\d{4}-\\d{2}-\\d{2}$$/', substr($$notas_aux1,0,15)) /*AND stripos(substr($$notas_aux1,26,45), \"envio mail a\", 0)==FALSE*/){",
"//echo \"@debug subsrt: \".substr($$notas_aux1,5,20).\"<br />\";",
"if($$i==0 OR $$fec_hora_aux1==substr($$notas_aux1,5,20)){",
"$$ultima_nota=$$notas_aux1.\"\\n\";",
"$$pos_ini_ultima_nota=strripos($$notas_aux2, \"#### \");",
"$$notas_aux2=substr($$notas_aux0, 0,strripos($$notas_aux2, \"#### \"));",
"$$i=1;",
"}else{",
"$$notas_aux2=substr($$notas_aux0, 0,strripos($$notas_aux2, \"#### \"));",
"break;",
"}",
"}else{",
"$$notas_aux2=substr($$notas_aux0, 0,strripos($$notas_aux2, \"#### \"));",
"}",
"}while($$notas_aux2!=\"\");",
"",
"##Separamos las notas previas de la última ingresada",
"$$notas_previas=substr($$notas_aux0, 0, $$pos_ini_ultima_nota-1);",
"",
"##Actualizamos el valor del campo notas anexas:",
"if($$pos_ini_ultima_nota!=\"\"){",
"$$notas_invertidas=$$ultima_nota.\"\\n\".$$notas_previas;",
"$$update_notas=\"UPDATE a0usr_form_acc_tarea set xcoment_anexo='\".addslashes($$notas_invertidas).\"' WHERE id='$$clave'\";",
"if(!sql_query($$update_notas, $$dbi)){",
"echo \"<b>Problemas al modificar el orden de las notas Anexas!</b>\";",
"}",
"}"
],
"description": "iw_template_posguardadonotas"
},
"iw_template_posguardadoadjuntos": {
"prefix": "iw_template_posguardadoadjuntos",
"body": [
"/**",
" * @file modificador.php",
" *",
" * Resumen de lo que hace este modificador",
" *",
" * A *description*, Este modificador es una prueba",
" * Tiene que seguir estos estandares de codificacion.",
" * Cliente J&B Solutions.",
" * Pos guardado archivos",
" *",
" * @version 3.9.1 2014-03-02 | Autor : XXX. Se hicieron cambios en modificador",
" * @version 3.9.2 2014-03-02 | Autor : XXX. Se hicieron cambios en modificador",
" * @version 4.0.0 2014-03-02 | Autor : XXX. Se hicieron cambios en modificador",
" * @version 4.0.1 2014-03-02 | Autor : XXX. Se hicieron cambios en modificador",
" *",
" * @copyright J&B Solutions SA",
" */",
"",
"$$sql=\"SELECT * FROM a0usr_da_ch_mk_publicidad WHERE id = '$$id_ot'\";",
"$$res= sql_query($$sql,$$dbi);",
"$$v = sql_fetch_array($$res,$$dbi);",
"",
"if($$v['xbloqueado']==\"1:2:3:4:6\"){ ",
"$$update_estado=\"UPDATE a0usr_da_ch_mk_publicidad SET cargo_adjunto_p5='1' WHERE id='$$id_ot'\";",
"if(!sql_query($$update_estado, $$dbi)){",
"iweb_alerts(\"Danger\",\"<b>¡Problema al actualizar la carga del adjunto!</b>\");",
"}",
"}"
],
"description": "iw_template_posguardadoadjuntos"
},
"iw_template_mascara_exporta": {
"prefix": "iw_template_mascara_exporta",
"body": [
"if (!preg_match(\"/modules.php/i\",htmlentities($$_SERVER['PHP_SELF']))){",
" die (\"You can't access this file directly...\");",
" }",
" require_once(\"mainfile.php\");",
" $$name = basename(dirname(__FILE__));",
" get_lang($$name);",
" ",
" $$sin_marco=\"N\";",
" $$veo_completo=\"S\";",
" $$titulo=\"Consulta de solicitudes\";",
" $$vmh = \"$$name | $$file\";",
" $$vmh_title = \"Control | Consulta de solicitudes\"; ",
" ",
" # Definici�n para la nueva versi�n de iWeb",
" $$Default_Theme = \"bootstrap\";",
" ",
" ",
" ",
" ## Si apreté el botón de exportar",
" if(isset($$exportar)){",
" $$exporta = 'S';",
" // echo \"<A HREF=\\\"$$hipervinculo_descarga_archivo\\\" target=\\\"_blank\\\"> Vinculo para descargar listado </a>\";",
" }",
" ",
" if($$exporta != 'S'){",
" include(\"header.php\");",
" $$class_textmore=\"class=\\\"textmore\\\"\";",
" }else{",
" $$class_textmore = \"\";",
" $$estilo_primera_col = \"style=\\\"background-color:#E8E8E8; vertical-align: top; height:40px;\\\"\";",
" $$estilo_filas = \"style=\\\"vertical-align: top;\\\"\";",
" $$boder_tabla = \" border=\\\"2\\\" \";",
" $$schema_insert=\"<html xmlns:o=\\\"urn:schemas-microsoft-com:office:office\\\"",
" xmlns:x=\\\"urn:schemas-microsoft-com:office:excel\\\"",
" xmlns=\\\"http://www.w3.org/TR/REC-html40\\\">",
" ",
" <!DOCTYPE html PUBLIC \\\"-//W3C//DTD XHTML 1.0 Transitional//EN\\\" \\\"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\\\">",
" <html>",
" <head>",
" <meta http-equiv=\\\"Content-type\\\" content=\\\"text/html;charset=ISO-8859-1\\\" />",
" ",
" </head>",
" <body>\";",
" $$what = \"excel\";",
" $$filename=\"Reporte_solicitudes\";",
" $$crlf = $$the_crlf = \"</tr>\\n\";",
" $$mime_type = \"application/vnd.ms-excel\";",
" $$separator = \"</td><td>\";",
" $$enclosed = '';",
" $$ext = \"xls\";",
" header('Content-Type: ' . $$mime_type);",
" ",
" header('Content-Disposition: attachment; filename=\"' . $$filename . \"_\".date(\"d-m-Y\").\".\" . $$ext . '\"');",
" header('Content-Type: application/force-download');",
" header('Expires: 0');",
" header('Pragma: no-cache'); ",
" ",
" }",
" hash_iweb_header();",
" include (\"includes/fmh.php\");",
" ####################################################################################################",
" ## 2) Inicio de variables, funciones y JavasScript",
" $$hoy=date('Y-m-d');",
" $$ahora=date('Y-m-d H:i');",
" $$searchButton = \"Buscar\";",
" $$resetButton = \"Reiniciar\";",
" $$notFoundText = \"No se encontraron registros\";",
" $$conjunto_connect = \"SELECT c.conjfun FROM nuke_users AS c WHERE c.uid=$$id_connect LIMIT 0,1\";",
" ",
" if(!isset($$pagesize))$$pagesize=20;",
" if(!isset($$sString)) $$sString=\"\";",
" if(!isset($$sStringNroregistro)) $$sStringNroregistro=\"\";",
" if(!isset($$min)) $$min=0;",
" if(!isset($$max)) $$max=$$min+$$pagesize;",
" if(!isset ($$sortby)) $$sortby=\"id\";",
" if(!isset ($$sortorder)) $$sortorder=\"DESC\" ;",
" if(!isset($$newArea)) $$newArea=\"\";",
" if(!isset($$newTAG)) $$newTAG=\"\";",
" ",
" ",
"// if($$estado1==0 AND $$estado2==0 AND $$estado3==0 AND $$estado4==0 AND $$estado5==0 AND $$estado6==0){",
"//$$estado1=1;",
"//$$estado2=0;",
"//$$estado3=0;",
"//$$estado4=0;",
"//$$estado5=0;",
"//$$estado6=0;",
"// }",
" ",
"// if($$estado6==1){",
"//$$estado1=$$estado2=$$estado3=$$estado4=$$estado5=1;",
"//$$estado6=0;",
"// }",
" ",
" if(($$parteActivaT1==0 AND $$parteActivaT2==0 AND $$parteActivaT3==0 AND $$parteActivaT4==0 AND $$parteActivaT5==0 AND $$parteActivaT6==0) OR $$parteActivaT6==1){",
" $$parteActivaT1=$$parteActivaT2=1;$$parteActivaT3=1;$$parteActivaT4=1;$$parteActivaT5=1;",
" $$parteActivaT6=0;",
" }",
" ",
" if(isset($$reset)) {",
" $$sString=\"\";",
" $$sStringNroregistro=\"\";",
" $$sStringRazonSocial=\"\";",
" $$newArea=\"\";",
" $$newTAG=\"\";",
" $$quienTieneActivo=\"\";",
" ",
" // $$estado1=1;",
" // $$estado2=0;",
" // $$estado3=0;",
" // $$estado4=0;",
" // $$estado5=0;",
" // $$estado6=0;",
" ",
" $$parteActivaT1=1;",
" $$parteActivaT2=1;",
" $$parteActivaT3=1;",
" $$parteActivaT4=1;",
" $$parteActivaT5=1;",
" $$parteActivaT6=0;",
" ",
" $$fecini=\"\";",
" $$fecfin=\"\";",
" $$bfecha= \"\";",
" $$pagesize=20;",
" $$min=0;",
" ",
" $$sortorder=\"DESC\";",
" $$sortby=\"id\";",
" }",
" ",
" $$asListCantRegistros[20]=\"20\";",
" $$asListCantRegistros[50]=\"50\";",
" $$asListCantRegistros[100]=\"100\";",
" ",
" $$asList['DESC']=\"Mayor a Menor\";",
" $$asList['ASC']=\"Menor a Mayor\";",
" ",
" $$orderbyList['id']=\"[ID] Nro.Registro\";",
" $$orderbyList['area']=\"Área\";",
" $$orderbyList['prov_razon_social']=\"Razón social\";",
" $$orderbyList['quien_lo_tiene_activo']=\"Quién lo tiene activo\"; ",
" $$orderbyList['desde_cuando_activa']=\"Desde cuando\";",
"// $$orderbyList['tag_rep']=\"TAG\";",
" ",
" $$select_field = \"SELECT *",
" FROM a0usr_fly_tm_tipocontrato ",
" WHERE 1\";",
"// echo \"<br>@debug $$select_xxxxxx \";",
" $$result_field = sql_query($$select_field,$$dbi);",
" $$nrows_field=sql_num_rows($$result_field,$$dbi);",
" $$str_result = array();",
" if($$nrows_field>0){",
" while ($$v_fi = sql_fetch_array($$result_field, $$dbi)){",
" $$lstTipoContrato[$$v_fi['id']] = $$v_fi['des'];",
" }",
" }",
" ",
"$$select_field = \"SELECT *",
" FROM a0usr_fly_tm_monedas ",
" WHERE 1\";",
"// echo \"<br>@debug $$select_xxxxxx \";",
" $$result_field = sql_query($$select_field,$$dbi);",
" $$nrows_field=sql_num_rows($$result_field,$$dbi);",
" $$str_result = array();",
" if($$nrows_field>0){",
" while ($$v_fi = sql_fetch_array($$result_field, $$dbi)){",
" $$lstMoneda[$$v_fi['id']] = $$v_fi['des'];",
" }",
" }",
" ",
"$$select_field = \"SELECT *",
" FROM a0usr_fly_tm_areas ",
" WHERE 1\";",
"// echo \"<br>@debug $$select_xxxxxx \";",
" $$result_field = sql_query($$select_field,$$dbi);",
" $$nrows_field=sql_num_rows($$result_field,$$dbi);",
" $$str_result = array();",
" if($$nrows_field>0){",
" while ($$v_fi = sql_fetch_array($$result_field, $$dbi)){",
" $$lstArea[$$v_fi['cod']] = $$v_fi['des'];",
" }",
" }",
" ",
" $$lstEstadoGral[0] = \"Solicitud de Contrato\";",
" $$lstEstadoGral[1] = \"Legales\";",
" $$lstEstadoGral[2] = \"Aprobación\";",
" $$lstEstadoGral[3] = \"Firmas\";",
" $$lstEstadoGral[4] = \"Finalizado\";",
" ",
"// ## LINK PARA EXPORTACION",
"// $$whereStringLink=\"\";",
"// $$whereStringPresenta=\"\";",
" ",
"// /* Texto simple*/ ",
"// if($$sStringNroregistro!=\"\"){",
"//if ($$whereStringLink!=\"\") {",
"//$$whereStringLink.=\" AND \";",
"//}",
"//$$whereStringPresenta .= \"<br> Nro Registro = \".$$sStringNroregistro.\"\";",
"//$$whereStringLink.=\" id_ot='\".addslashes_jbs($$sStringNroregistro).\"'\";",
"// }",
" ",
"// /* Checkbox */",
"// if($$parteActivaT1==1){",
"//$$whereStringPresenta .= \"<br> Ubicación = \".$$lstUbicacion[0].\"\";",
"//$$whereStringCheckPActivaLink.=\" ubicacion='0'\";",
"// }",
"// if($$parteActivaT2==1){",
"//$$whereStringPresenta .= \"<br> Ubicación = \".$$lstUbicacion[1].\"\";",
"//if($$whereStringCheckPActivaLink!=\"\") $$whereStringCheckPActivaLink.=\" OR \";",
"//$$whereStringCheckPActivaLink.=\" ubicacion='1'\";",
"// } ",
"// if($$parteActivaT1==1 AND $$parteActivaT2==1) {",
"//$$whereStringCheckPActivaLink=\"\";",
"// } ",
"// if ($$whereStringCheckPActivaLink!=\"\") {",
"//if ($$whereStringLink!=\"\") {",
"//$$whereStringLink.=\" AND \";",
"//}",
"//$$whereStringLink.=\" ($$whereStringCheckPActivaLink)\";",
"// }",
" ",
"// /* LOV TAG */",
"// if($$newTAG!=\"\"){",
"//if ($$whereStringLink!=\"\") {",
"//$$whereStringLink.=\" AND \";",
"//}",
"//$$whereStringPresenta .= \"<br> Tag = \".$$lstTAG[$$newTAG].\"\";",
"//$$whereStringLink.=\" tag_rep='\".addslashes_jbs($$newTAG).\"'\";",
"// }",
"// /* LOV */",
"// if($$newArea!=\"\"){",
"//if ($$whereStringLink!=\"\") {",
"//$$whereStringLink.=\" AND \";",
"//}",
"//$$whereStringPresenta .= \"<br> Área = \".$$lstArea[$$newArea].\"\";",
"//$$whereStringLink.=\" planta_rep='\".addslashes_jbs($$newArea).\"'\";",
"// }",
"// /* FECHAS */",
"// if ($$fecini!=\"\" OR $$fecfin!=\"\") $$whereStringPresenta .= \"<br> Fecha de ingreso a taller = \";",
"// if ($$fecini!=\"\"){",
"//if ($$whereStringLink!=\"\") {",
"//$$whereStringLink.=\" AND \";",
"//}",
"//$$whereStringPresenta .= \"\\n Desde = \".$$fecini.\"\";",
"//$$whereStringLink .= \" fecha_ingreso >= '$$fecini' \";",
"// }",
"// if ($$fecfin!=\"\"){",
"//if ($$whereStringLink!=\"\") {",
"//$$whereStringLink.=\" AND \";",
"//}",
"//$$whereStringPresenta .= \" Hasta = \".$$fecfin.\"\";",
"//$$whereStringLink .= \" fecha_ingreso <= '$$fecfin' \";",
"// }",
"// $$select_REPO = \"SELECT * ",
"//FROM `nuke_sgc_reportes`",
"//WHERE num_form = 'R-SH-REPARACION-EQUIPO' AND estado = 2",
"//ORDER BY rev DESC",
"//LIMIT 0,1\";",
"// $$result_REPO = sql_query($$select_REPO,$$dbi);",
"// $$vREPO = sql_fetch_array($$result_REPO, $$dbi);",
"// $$hipervinculo_descarga =\"$$nukeurl/modules.php?name=sgc_analisis&file=genera&do=generalistado&xmenu=$$xmenu&zzmenu=$$zzmenu&arch=s&id_form=\".$$vREPO['id_form'].\"\";",
"// $$hipervinculo_descarga.=\"&sortby1=id&sortorder1=DESC&sortby2=0&sortorder2=ASC&sortby3=0&sortorder3=ASC&parteActivaTodos=S\"; //&debug_sql_repo=S",
"// if ($$whereStringLink!=\"\") {",
"//$$hipervinculo_descarga.=\"&def_where= $$whereStringLink\";",
"// }",
" ",
"// if ($$whereStringPresenta!=\"\") {",
"//$$hipervinculo_descarga.=\"&presenta_condiciones=$$whereStringPresenta\";",
"// }",
"// // echo \"<b>@debug</b> - variable HREFDESCARGA: $$hipervinculo_descarga<br>\";",
"// $$hipervinculo_descarga_archivo = hash_iweb_encode_url($$hipervinculo_descarga);",
" ",
" ## Buscamos el id de formulario",
" $$select_tables = \"SELECT id_form, tabla_afecta ",
" FROM nuke_sgc_formularios",
" WHERE num_form = 'FLY-SOL-CONTRATOS'\";",
"// echo \"<br>@debug $$select_xxxxxx \";",
" $$result_xtable = sql_query($$select_tables,$$dbi);",
" $$nrows_tab=sql_num_rows($$result_xtable,$$dbi);",
" $$v_tab = sql_fetch_array($$result_xtable, $$dbi);",
" ",
" ####################################################################################################",
" # 4) PARAMETROS DE BUSQUEDA",
" if($$exporta == 'S'){",
" echo $$schema_insert; ",
" }else{",
" ",
"//echo \"<script type=\\\"text/javascript\\\">\\n\";",
"//echo \"<!--\\n\";",
"//echo \"function abrewindow(hlp){\\n\";",
"//echo \"window.open (hlp,'iWeb','toolbar=no,location=no,directories=no,status=no,scrollbars=yes,resizable=no,copyhistory=no,width=850,height=550');\\n\";",
"//echo \"}\\n\";",
"//echo \"//-->\\n\";",
"//echo \"</SCRIPT>\\n\\n\";",
" ",
" OpenDivMascara();",
" echo \"<form name=\\\"dbConsulta\\\" method=\\\"post\\\" action=\\\"\".hash_iweb_encode_url(\"modules.php?name=$$name&file=$$file\").\"\\\">\\n\";",
" hash_iweb_form();",
" echo \"<input type=\\\"hidden\\\" name=\\\"xmenu\\\" value=\\\"$$xmenu\\\">\\n\";",
" echo \"<input type=\\\"hidden\\\" name=\\\"sortby\\\" value=\\\"\".htmlentities_jbs($$sortby).\"\\\">\\n\";",
" echo \"<input type=\\\"hidden\\\" name=\\\"sortorder\\\" value=\\\"\".htmlentities_jbs($$sortorder).\"\\\">\\n\"; ",
" ",
" $$xform=\"dbConsulta\";",
" echo \"<input type=\\\"hidden\\\" name=\\\"xmenu\\\" value=\\\"$$xmenu\\\">\\n\";",
" echo \"<input type=\\\"hidden\\\" name=\\\"name\\\" value=\\\"$$name\\\">\\n\";",
" echo \"<input type=\\\"hidden\\\" name=\\\"file\\\" value=\\\"$$file\\\">\\n\";",
" echo \"<table class=\\\"table table-iweb table-bordered table-iweb-centrada\\\">",
" <!-- Tabla para filtros-->\\n\";",
" /***************",
" * CAMPOS DE BUSQUEDA",
" **************/ ",
"//echo \"<tr>\";",
"// echo \"<td><span class=\\\"label label-warning\\\">Chequear errores <br>de SQL en el log enFiles/site/sql_logs<br>/error_AAAAMMDD.txt</span></td>",
"// <td></td>\";",
"// echo \"</tr>\\n\";",
" ",
"// /* LOV */",
"// echo \"<tr>\";",
"// echo \" <td>Nro TAG</td>\\n\"; ",
"// echo \" <td>\".lov_modal_iweb('Nro TAG','a0usr_sh_ficha_equipos_rotativos',$$xform,'newTAG','id,tag,nro_registro_bomba',\"\",$$newTAG,\"S\",\"C1,C2,L\",1,\"\",10,\"N\").\"</td>\\n\";",
"// echo \"</tr>\\n\";",
" ",
" /* Texto simple*/ ",
" echo \"<tr>\";",
" echo \" <td width=\\\"30%\\\">[ID] Nro.Registro</td>\";",
" echo \" <td>\";",
" echo \" <div class=\\\"form-inline\\\" id=\\\"tabla_filtros\\\">\";",
" echo iw_dibuja_text(\"sStringNroregistro\",$$sStringNroregistro, \"40\", \"40\",$$id=\"\"); ",
" echo \" </div>\\n\";#Cierre Form-inline",
" echo \" </td>\\n\";",
" echo \"</tr>\\n\";",
" ",
" /* LOV */",
" echo \"<tr>\";",
" echo \" <td>Área</td>\\n\"; ",
" $$whereFiltroArea = \" (1=(SELECT 1 FROM a0usr_fly_tm_perfil_acceso AS d WHERE d.conjunto_grupo=($$conjunto_connect) AND d.acceso=1) OR f.cod IN(SELECT b.area FROM a0usr_fly_tm_perfil_acceso AS b WHERE b.conjunto_grupo=($$conjunto_connect) AND b.acceso=0))\";",
" echo \" <td>\".lov_modal_iweb('Área','a0usr_fly_tm_areas AS f',$$xform,'newArea','f.cod as Código,f.cod as Código,f.des as Descripción',$$whereFiltroArea,$$newArea,\"S\",\"C1,C2,L\",1,\"\",10,\"N\").\"</td>\\n\";",
" echo \"</tr>\\n\";",
" ",
" /* Texto simple*/ ",
" echo \"<tr>\";",
" echo \" <td width=\\\"30%\\\">Razón social</td>\";",
" echo \" <td>\";",
" echo \" <div class=\\\"form-inline\\\" id=\\\"tabla_filtros\\\">\";",
" echo iw_dibuja_text(\"sStringRazonSocial\",$$sStringRazonSocial, \"40\", \"40\",$$id=\"\"); ",
" echo \" </div>\\n\";#Cierre Form-inline",
" echo \" </td>\\n\";",
" echo \"</tr>\\n\";",
" ",
"// $$java_lov = \"if(document.$$xform.newArea.value == pref0){ ",
"// alert('Opción ya seleccionada!');",
"// return;",
"// }\";",
"// /* LOV */",
"// echo \"<tr>\";",
"// echo \" <td>YYYY</td>\\n\"; ",
"// echo \" <td>\".lov_modal_iweb('Usuarios del sistema (No Repite)',_IW_USERS,$$xform,'newuser_nr','uid,uname as Usuario,name as Apellido Nombre',\"\",$$newuser_nr,\"S\",\"C1,C2,L\",1,\"\",10,\"N\", \"12,45\", $$java_lov).\"</td>\\n\";",
"// echo \"</tr>\\n\";",
" ",
"// /* LOV Corto */",
"// echo \"<tr class=\\\"iweb_filtros_avanzados\\\">\\n\";",
"// echo \" <td>LOV Modal - Usuario INNER JOIN ACciones <br /><b>lov_modal_iweb()</b></td>\\n\"; ",
"// echo \" <td>\".lov_modal_iweb('Usuarios del sistema y Sus acciones pendientes',_IW_USERS,$$xform,'quienTieneActivo2','uid,uname as Usuario,name as Apellido Nombre4, (SELECT count(*) FROM `a0usr_acciones_segumiento` WHERE responsable_accion = uid ) as Acc_Pendientes',\"\",$$quienTieneActivo2,\"S\",\"C1,C2,L\",1,\"\",10,\"N\").\"</td>\\n\";",
"// echo \"</tr>\\n\";",
" ",
" /* Checkbox */",
" if($$parteActivaT1==1){",
" $$checked_parteActivaT1=\"CHECKED\";",
" }",
" if($$parteActivaT2==1){",
" $$checked_parteActivaT2=\"CHECKED\";",
" }",
" if($$parteActivaT3==1){",
" $$checked_parteActivaT3=\"CHECKED\";",
" }",
" if($$parteActivaT4==1){",
" $$checked_parteActivaT4=\"CHECKED\";",
" }",
" if($$parteActivaT5==1){",
" $$checked_parteActivaT5=\"CHECKED\";",
" }",
" if($$parteActivaT6==1){",
" $$checked_parteActivaT1=\"CHECKED\";",
" $$checked_parteActivaT2=\"CHECKED\";",
" $$checked_parteActivaT3=\"CHECKED\";",
" $$checked_parteActivaT4=\"CHECKED\";",
" $$checked_parteActivaT5=\"CHECKED\";",
" }",
" ",
" echo \"<tr class=\\\"iweb_filtros_avanzados\\\">\";",
" echo \" <td>Parte activa</td>\";",
" echo \" <td>\";",
" echo \" <div class=\\\"form-inline\\\">\";",
" echo iw_dibuja_checkbox(\"parteActivaT1\", \"Sol. de contrato \", $$checked_parteActivaT1 ,1);",
" echo iw_dibuja_checkbox(\"parteActivaT2\", \"Legales \", $$checked_parteActivaT2 ,1);",
" echo iw_dibuja_checkbox(\"parteActivaT3\", \"Aprobación \", $$checked_parteActivaT3 ,1);",
" echo iw_dibuja_checkbox(\"parteActivaT4\", \"Firmas \", $$checked_parteActivaT4 ,1);",
" echo iw_dibuja_checkbox(\"parteActivaT5\", \"Finalizado \", $$checked_parteActivaT5 ,1);",
" echo iw_dibuja_checkbox(\"parteActivaT6\", \"Todos \", $$checked_parteActivaT6 ,1);",
" echo \" </div>\\n\";",
" echo \" </td>\";",
" echo \"</tr>\";",
" ",
"// /* RADIO button */",
"// echo \"<tr class=\\\"iweb_filtros_avanzados\\\">\";",
"// echo \" <td>Radio Button <br /><b>iw_dibuja_radio_button()</b></td>\";",
"// echo \" <td>\";",
"// echo \" <div class=\\\"form-inline\\\">\";",
"// echo iw_dibuja_radio_button(\"radio_button\", \" General OT \" , \"\", \"0\");",
"// echo iw_dibuja_radio_button(\"radio_button\", \" Diferencia en items (std vs real)\" , \"checked\", \"1\");",
"// echo \" </div>\";",
"// echo \" </td>\";",
"// echo \"</tr>\";",
" ",
" /* LOV Corto */",
" echo \"<tr class=\\\"iweb_filtros_avanzados\\\">\\n\";",
" echo \" <td>Quién lo tiene activo</td>\\n\"; ",
" echo \" <td>\".lov_modal_iweb('Usuarios del sistema',_IW_USERS,$$xform,'quienTieneActivo','uid,uname as Usuario,name as Apellido Nombre',\"\",$$quienTieneActivo,\"S\",\"C1,C2,L\",1,\"\",10,\"N\").\"</td>\\n\";",
" echo \"</tr>\\n\";",
" ",
" /* FECHAS */",
" echo \"<tr class=\\\"iweb_filtros_avanzados\\\">\";",
" echo \" <td>Desde cuando</td>\\n\";",
" echo \" <td>\";",
" echo \" <div class=\\\"form-inline\\\">\\n\";",
" echo \" Desde \". iw_dibuja_fecha(\"fecini\",$$fecini).\" Hasta \".iw_dibuja_fecha(\"fecfin\",$$fecfin);",
" echo \" </div>\";",
" echo \" </td>\\n\";",
" echo \"</tr>\";",
" ",
" /* LIST */",
" echo \"<tr class=\\\"iweb_filtros_avanzados\\\">\\n\";",
" echo \" <td>Ordenar por</td>\\n\";",
" echo \" <td>\\n\";",
" echo \" <div class=\\\"form-inline\\\">\\n\"; ",
" echo \" <select name=\\\"sortby\\\" class=\\\"form-control input-sm\\\">\";",
" foreach($$orderbyList as $$n3 => $$element3) {",
" $$selected = \"\";",
" if ($$n3==$$sortby){",
" $$selected = \"selected\";",
" }",
" echo iw_dibuja_lista($$element3, $$n3, $$selected);",
" }",
" echo \" </select>\";",
" ",
"// echo \" <div class=\\\"form-inline\\\">\\n\"; ",
" echo \" <select name=\\\"sortorder\\\" class=\\\"form-control input-sm\\\">\";",
" foreach($$asList as $$n3 => $$element3) {",
" $$selected = \"\";",
" if ($$n3==$$sortorder){",
" $$selected = \"selected\";",
" }",
" echo iw_dibuja_lista($$element3, $$n3, $$selected);",
" }",
" echo \" </select>\";",
" ",
" echo \" <select name=\\\"pagesize\\\" class=\\\"form-control input-sm\\\">\";",
" foreach($$asListCantRegistros as $$n3 => $$element3) {",
" $$selected = \"\";",
" if ($$n3==$$pagesize){",
" $$selected = \"selected\";",
" }",
" echo iw_dibuja_lista($$element3, $$n3, $$selected);",
" }",
" echo \" </select>\";",
" ",
" echo \" </div>\\n\";",
" echo \"</td>\\n\";",
" echo \"</tr>\\n\";",
" ",
" echo \"<tr>\\n\";",
" echo \" <td colspan=\\\"2\\\" class=\\\"text-center\\\"><input type=\\\"submit\\\" name=\\\"buscar\\\" value=\\\"$$searchButton\\\" class=\\\"btn btn-default btn-sm\\\"> <input type=\\\"submit\\\" name=\\\"reset\\\" value=\\\"$$resetButton\\\" class=\\\"btn btn-default btn-sm\\\">\";",
" echo \" <button type=\\\"submit\\\" name=\\\"exportar\\\" class=\\\"btn btn-default btn-sm\\\"><i class=\\\"fa fa-download\\\" aria-hidden=\\\"true\\\"></i> Exportar</button>\\n\";",
" ",
"// echo \" <a href=\\\"$$hipervinculo_descarga_archivo\\\" class=\\\"btn btn-default btn-sm\\\"><i class=\\\"fa fa-download\\\" aria-hidden=\\\"true\\\"></i> Exportar <b><small>(Primero Buscar)</small></b></a>\\n\";",
" ",
" iweb_filtros_avanzados(\"tabla_filtros\", \"Filtros Avanzados (<b>iweb_filtros_avanzados()</b>)\", \"black\");",
" echo\"</td>\\n\";",
" echo \"</tr>\\n\";",
" echo \"<tr><td colspan=2>\";",
" ",
" echo \"</td></tr>\";",
" echo \"</table>\\n\";",
" ",
" echo \"</form>\";",
" ",
" CloseDivMascara();",
" ",
" }",
" ####################################################################################################",
" # 5) ARMAR CONSULTA DE DATOS CON LOS FILTROS MARCADOS",
" #Armo whereString para buscar en base lo que se elije arriba",
" $$whereString=\"1\";",
" ",
" /* ID */ ",
" if($$sStringNroregistro!=\"\"){",
" if ($$whereString!=\"\") {",
" $$whereString.=\" AND \";",
" }",
" $$whereString.=\" a.id='\".addslashes_jbs($$sStringNroregistro).\"'\";",
" }",
" ",
" /* Razon social */ ",
" if($$sStringRazonSocial!=\"\"){",
" if ($$whereString!=\"\") {",
" $$whereString.=\" AND \";",
" }",
" $$whereString.=\" a.prov_razon_social LIKE '%\".addslashes_jbs($$sStringRazonSocial).\"%'\";",
" }",
" ",
" /* LOV TAG */",
" if($$newTAG!=\"\"){",
" if ($$whereString!=\"\") {",
" $$whereString.=\" AND \";",
" }",
" $$whereString.=\" a.quien_lo_tiene_activo='\".addslashes_jbs($$quienTieneActivo).\"'\";",
" }",
" ",
" /* LOV */",
" if($$newArea!=\"\"){",
" if ($$whereString!=\"\") {",
" $$whereString.=\" AND \";",
" }",
" $$whereString.=\" a.area='\".addslashes_jbs($$newArea).\"'\";",
" }",
" ",
" /* FECHAS */",
" if ($$fecini!=\"\"){",
" if ($$whereString!=\"\") {",
" $$whereString.=\" AND \";",
" }",
" $$whereString .= \" a.desde_cuando_activa >= '$$fecini' \";",
" }",
" if ($$fecfin!=\"\"){",
" if ($$whereString!=\"\") {",
" $$whereString.=\" AND \";",
" }",
" $$whereString .= \" a.desde_cuando_activa <= '$$fecfin' \";",
" }",
" ",
" ",
"// /* LOV Corto */",
"// if($$quienTieneActivo!=\"\"){",
"//if ($$whereString!=\"\") {",
"//$$whereString.=\" AND \";",
"//}",
"//$$whereString.=\" a.quienTieneActivo='\".addslashes_jbs($$quienTieneActivo).\"'\";",
"// }",
" ",
"// /* LIST */",
"// if($$sortby!=\"\"){",
"//if ($$whereString!=\"\") {",
"//$$whereString.=\" AND \";",
"//}",
"//$$whereString.=\" a.sortby='\".addslashes_jbs($$sortby).\"'\";",
"// }",
" ",
" /* Checkbox */",
" if($$parteActivaT1==1){",
" $$whereStringCheckPActiva.=\" a.x_edita='0'\";",
" }",
" if($$parteActivaT2==1){",
" if($$whereStringCheckPActiva!=\"\") $$whereStringCheckPActiva.=\" OR \";",
" $$whereStringCheckPActiva.=\" a.x_edita='1'\";",
" } ",
" if($$parteActivaT3==1){",
" if($$whereStringCheckPActiva!=\"\") $$whereStringCheckPActiva.=\" OR \";",
" $$whereStringCheckPActiva.=\" a.x_edita='2'\";",
" } ",
" if($$parteActivaT4==1){",
" if($$whereStringCheckPActiva!=\"\") $$whereStringCheckPActiva.=\" OR \";",
" $$whereStringCheckPActiva.=\" a.x_edita='3'\";",
" } ",
" if($$parteActivaT5==1){",
" if($$whereStringCheckPActiva!=\"\") $$whereStringCheckPActiva.=\" OR \";",
" $$whereStringCheckPActiva.=\" a.x_edita='4'\";",
" } ",
" if($$parteActivaT6==1){",
" $$whereStringCheckPActiva=\"\";",
" } ",
" ",
" if ($$whereStringCheckPActiva!=\"\") {",
" $$whereString.=\" AND ($$whereStringCheckPActiva)\";",
" }",
" ",
"// /* Checkbox */",
"// if($$estado1==1){",
"//$$whereStringCheck.=\" a.estado='0'\";",
"// }",
"// if($$estado2==1){",
"//if($$whereStringCheck!=\"\") $$whereStringCheck.=\" OR \";",
"//$$whereStringCheck.=\" a.estado='1'\";",
"// } ",
"// if($$estado3==1){",
"//if($$whereStringCheck!=\"\") $$whereStringCheck.=\" OR \";",
"//$$whereStringCheck.=\" a.estado='2'\";",
"// } ",
"// if($$estado4==1){",
"//if($$whereStringCheck!=\"\") $$whereStringCheck.=\" OR \";",
"//$$whereStringCheck.=\" a.estado='3'\";",
"// } ",
"// if($$estado5==1){",
"//if($$whereStringCheck!=\"\") $$whereStringCheck.=\" OR \";",
"//$$whereStringCheck.=\" a.estado='4'\";",
"// } ",
"// if($$estado6==1){",
"//$$whereStringCheck.=\"\";",
"// } ",
" ",
"// if ($$whereStringCheck!=\"\") {",
"//$$whereString.=\" AND ($$whereStringCheck)\";",
"// }",
" ",
"// /* RADIO button */",
"// if($$radio_button!=\"\"){",
"//if ($$whereString!=\"\") {",
"//$$whereString.=\" AND \";",
"//}",
"//$$whereString.=\" a.radio_button='\".addslashes_jbs($$radio_button).\"'\";",
"// }",
" ",
" $$whereFiltroAreaString = \" (1=(SELECT 1 FROM a0usr_fly_tm_perfil_acceso AS d WHERE d.conjunto_grupo=($$conjunto_connect) AND d.acceso=1) OR a.area IN(SELECT b.area FROM a0usr_fly_tm_perfil_acceso AS b WHERE b.conjunto_grupo=($$conjunto_connect) AND b.acceso=0))\";",
" if ($$whereString!=\"\"){",
" $$whereString = \" WHERE \".$$whereString.\" AND $$whereFiltroAreaString\";",
" } ",
" ",
" $$sql = \"SELECT a.*",
" FROM vw_fly_sol_contratos as a",
" \";",
" $$sql.=\" $$whereString ORDER BY \".addslashes_jbs($$sortby).\" \".addslashes_jbs($$sortorder);",
" $$sql0=$$sql;",
" ",
" if($$exporta != 'S'){ ",
" $$sql0.=xLIMIT($$dbtype, $$min,$$pagesize);",
" // echo \"<br />@debug - Auditoria sql con filtros aplicados: \".htmlentities($$sql0).\"<br>\";",
" }",
"// if ($$id_connect == 2) echo \"<br />@debug - Auditoria sql con filtros aplicados: \".htmlentities($$sql0).\"<br>\";",
" ",
"// ///// PARA QUE MUESTRE SIEMPRE DATOS LA TABLA INDEPENDIENTEMENTE DE los filtros ",
"// $$sql = \"SELECT a.* FROM a0usr_f_018 as a ORDER BY \".addslashes_jbs($$sortby).\" \".addslashes_jbs($$sortorder);",
"// $$sql.=xLIMIT($$dbtype, $$min,$$pagesize);",
"// echo \"<br />@debug - Auditoria sql datos tabla : \".htmlentities($$sql).\"<br>\";",
" $$result = sql_query($$sql0, $$dbi); ",
" ",
" ",
" $$nrows=0;",
" $$nrows=sql_num_rows($$result, $$dbi);",
" $$x=0;",
" ",
" ####################################################################################################",
" # 6) PRESENTACION DE DATOS",
" if($$exporta != 'S'){",
" OpenDivMascaraAmplio();",
" }",
" ",
" echo \"<table class=\\\"table table-iweb table-bordered table-hover table-iweb-centrada\\\">\";",
" ",
" $$param_extra=\"&fecini=$$fecini&fecfin=$$fecfin&newArea=$$newArea&quienTieneActivo=$$quienTieneActivo&newTAG=$$newTAG&sStringNroregistro=$$sStringNroregistro&sStringRazonSocial=$$sStringRazonSocial&parteActivaT1=$$parteActivaT1&parteActivaT2=$$parteActivaT2&parteActivaT3=$$parteActivaT3&parteActivaT4=$$parteActivaT4&parteActivaT5=$$parteActivaT5&parteActivaT6=$$parteActivaT6&\";",
"// estado1=$$estado1&estado2=$$estado2&estado3=$$estado3&estado4=$$estado4&estado5=$$estado5&estado6=$$estado6&parteActivaT1=$$parteActivaT1&parteActivaT2=$$parteActivaT2&parteActivaT3=$$parteActivaT3&parteActivaT4=$$parteActivaT4",
" $$param_extra.=\"sortorder=$$sortorder&sortby=$$sortby&pagesize=$$pagesize&offset=$$offset&min=$$min&xmenu=$$xmenu\";",
"// $$base_link.= $$param_extra;",
" ",
"// if ($$id_connect == 76) echo \"<br />@debug - PARAM: \".htmlentities($$param_extra).\"<br>\";",
" /**Encabezado*/",
" echo \"<thead><tr class=\\\"text-center table-iweb-firstrow\\\" >\\n\";",
" ",
"// iw_sort_url_icon($$sortby, \"id\", $$sortorder, $$ordenando, $$icon_sort);",
"// <a href=\\\"\".hash_iweb_encode_url(\"modules.php?op=modload&name=$$name&file=$$file\".\"$$ordenando\".$$base_link).\"\\\"></a>",
"// $$icon_sort",
" echo \" <th><i class=\\\"fa fa-pencil-square-o fa-lg\\\" aria-hidden=\\\"true\\\"></i> ID</td>\\n\";",
" echo \" <th>Área</th>\\n\";",
" echo \" <th>Razón social</th>\\n\";",
" echo \" <th>Resumen del contrato</th>\\n\";",
" echo \" <th>Parte activa</th>\\n\";",
" echo \" <th>Quién lo tiene activo</th>\\n\";",
" echo \" <th>Desde cuando</th>\\n\";",
" if($$exporta != 'S'){",
" echo \" <th>Adjuntos</th>\\n\";",
" }",
" echo \"</tr></thead>\\n\";",
" /**Fin Encabezado*/",
" ",
" if($$nrows>0) {",
" while($$v = sql_fetch_array($$result, $$dbi)) {",
" echo \"<tr>\\n\";",
" ",
" $$href = \"$$nukeurl/modules.php?name=sgc_registracion&file=genera2®istro=\".$$v['id'].\"&do=presentaform2&id_form=\".$$v_tab['id_form'].\"&xmenu=$$xmenu\";",
" $$link = hash_iweb_encode_url($$href);",
" echo \" <td nowrap><a href=\\\"$$link\\\" target=\\\"_BLANK\\\" ><i class=\\\"fa fa-pencil-square-o fa-1x\\\" aria-hidden=\\\"true\\\"> \".htmlentities_jbs($$v['id']).\"</a></td>\\n\";",
" ",
" echo \" <td>\".htmlentities_jbs($$lstArea[$$v['area']]).\"</td>\\n\";",
" echo \" <td>\".htmlentities_jbs($$v['prov_razon_social']).\"</td>\\n\";",
" echo \" <td>\".htmlentities_jbs($$v['resumen_contrato']).\"</td>\\n\";",
" echo \" <td>\".htmlentities_jbs($$lstEstadoGral[$$v['x_edita']]).\"</td>\\n\";",
" echo \" <td>\".htmlentities_jbs($$User_iWebList[$$v['quien_lo_tiene_activo']][1]).\"</td>\\n\";",
" echo \" <td>\".htmlentities_jbs($$v['desde_cuando_activa']).\"</td>\\n\";",
" ",
" if($$exporta != 'S'){",
" ## Listado de adjuntos",
" echo \" <td>\";",
" ###### visualización archivos adjuntos",
" $$sql_doc =\" SELECT a.id, a.id_form, a.id_ot, a.url, a.name, a.date, a.elaboro,b.name,a.parte",
" FROM \"._IW_SGC_FORMULARIOS_FILES.\" as a",
" INNER JOIN \"._IW_USERS.\" as b ON a.elaboro=b.uid",
" WHERE id_ot='\".addslashes_jbs($$v['id']).\"' AND id_form='\".addslashes_jbs($$v_tab['id_form']).\"' ",
" ORDER by a.parte,a.id\";",
" ",
" // echo \"<br>Hola 198 $$sql_doc\";",
" $$result_doc = sql_query($$sql_doc, $$dbi);",
" $$nrows_doc = sql_num_rows($$result_doc, $$dbi);",
" ",
" if ($$nrows_doc>0) {",
" echo \"<table class=\\\"table table-iweb table-bordered\\\" cellspacing=\\\"4\\\">\";",
" echo \"<tr bgcolor=\\\"#FFFFFF\\\"><td><b>Doc.</b>",
" </td>",
" ",
" <td><b>Tema </b></td>",
" </tr>\";",
" while(list($$vid, $$vid_form, $$vid_accion, $$vurl, $$vname, $$vdate, $$velaboro,$$vusuario ,$$vparte) = sql_fetch_row($$result_doc, $$rdbi)) {",
" $$suffix = strtolower(substr(trim($$vurl), -3));",
" $$posicio_ultimo_punto = strripos($$vurl,\".\");",
" $$suffix=strtolower(substr(trim($$vurl), $$posicio_ultimo_punto+1,strlen($$vurl)-$$posicio_ultimo_punto));",
" if (in_array($$suffix, $$picArr)) {",
" $$pic = \"images/archives/$$suffix.gif\";",
" }else{",
" $$pic = \"images/archives/ukn.gif\";",
" }",
" $$url2=urlencode($$vurl);",
" $$archivesFilesFolder=$$GLOBALS['constante_directorio_file'].\"/files_registracion/\";",
" $$archivo_base = \"$$archivesFilesFolder$$url2\";",
" $$archivo = base64_encode(base64_encode($$archivo_base).\"||$$id_connect||\".md5($$archivo_base));",
" $$href=hash_iweb_encode_url(\"$$nukeurl/modules.php?name=sgc_xmuestra&file=iweb_download&getfile=$$archivo&name_iw_d=$$vname\");",
" ",
" echo \"<tr><td class=\\\"text-center\\\">",
" <a href=\\\"$$href\\\" target=\\\"_blank\\\"><img src=\\\"$$pic\\\" width=\\\"16\\\" border=\\\"0\\\" alt=\\\"Ver archivo\\\"></a></td>",
" ",
" <td>$$vname</td>",
" </tr>\";",
" }",
" ###### fin archivos adjuntos",
" echo \"</table>\";",
" }",
" echo\"</td>\\n\";",
" }",
" echo \"</tr>\\n\";",
" $$x++;",
" }",
" echo \"</table>\";",
" }else{",
" $$colspan = \"8\";",
" echo \"<tr>\";",
" echo \" <td colspan=\\\"$$colspan\\\">$$notFoundText</td>\";",
" echo \"</tr>\";",
" echo \"</table>\";",
" } ",
" ",
" if($$exporta != 'S'){",
" ####################################################################################################",
" # 7) PAGINACION",
" $$ruta=\"modules.php?op=modload&name=$$name&file=$$file&xmenu=$$xmenu\";",
" $$ruta.=$$param_extra;",
" ",
" paginacionMascara($$ruta,$$min,$$x,$$pagesize);",
" CloseDivMascaraAmplio();",
" ",
" # 8) Cierre de la MASCARA",
" include(\"footer.php\");",
" unset($$veo_completo);",
" echo \"<script>\";",
" echo \" $$('.textmore').readmore({",
" speed: 75,",
" collapsedHeight: 120,",
" moreLink: '<a href=\\\"#\\\">\"._READMORE.\"</a>',",
" lessLink: '<a href=\\\"#\\\">\"._READLESS.\"</a>'",
" });\";",
" echo \"</script>\"; ",
" }"
],
"description": "iw_template_mascara_exporta"
},
"iw_template_mascara_zdefiniciones": {
"prefix": "iw_template_mascara_zdefiniciones",
"body": [
"####################################################################################################",
"## 1) Definición de seguridad, variables del sistema e inclusión de archivos principales",
"if (!preg_match(\"/modules.php/i\",htmlentities(\\$_SERVER['PHP_SELF']))){",
"die (\"You can't access this file directly...\");",
"}",
"require_once(\"mainfile.php\");",
"\\$name = basename(dirname(__FILE__));",
"get_lang(\\$name);",
"",
"\\$sin_marco=\"N\";",
"\\$veo_completo=\"S\";",
"\\$titulo=\"MENU MASCARAS MODELO\";",
"\\$vmh = \"\\$name | \\$file\";",
"\\$vmh_title = \"\\$name | \\$file\"; ",
"",
"# Definición para la nueva versión de iWeb",
"\\$Default_Theme = \"bootstrap\";",
"include(\"header.php\");",
"hash_iweb_header();",
"include (\"includes/fmh.php\");",
"####################################################################################################",
"## 2) Inicio de variables, funciones y JavasScript",
"\\$hoy=date('Y-m-d');",
"\\$ahora=date('Y-m-d H:i');",
"/*\\$searchButton = \"Buscar\";",
"\\$resetButton = \"Reiniciar\";",
"\\$notFoundText = \"\"._NOMATCHES.\"\";",
"if(!isset(\\$pagesize))\\$pagesize=20;*/",
]
},
"iw_consulta_select_list_jbs": {
"prefix": "iw_consulta_select_list_jbs",
"body": [
"## ${3:Comentarios}",
"\\$select_${1:xxxxxx} = \"SELECT max(fecha) FROM ${2:nombre_tabla} WHERE id =\\$clave \";",
"\\$result_${1:xxxxxx} = sql_query(\\$select_${1:xxxxxx},\\$dbi);",
"\\$nrows_${1:xxxxxx} = sql_num_rows(\\$result_${1:xxxxxx},\\$dbi);",
"if(\\$nrows_${1:xxxxxx}>0){",
" list(\\$max_fecha) = sql_fetch_row(\\$result_${1:xxxxxx}, \\$dbi); " ,
"}",
]
},
"iw_consulta_select_v_registro_jbs": {
"prefix": "iw_consulta_select_v_registro_jbs",
"body": [
"$$strCamposGet=\"id,id_connect,x_usr1,x_fec_usr1\";",
"$$cond_ad=\"\"; //\"AND cod='ABC'\";",
"$$v=iw_getRegistro($$tabla, $$clave, $$strCamposGet,$$cond_ad);"
],
"description": "iw_consulta_select_v_array_jbs"
},
"iw_consulta_select_array_jbs": {
"prefix": "iw_consulta_select_array_jbs",
"body": [
"$$sel_fieldString=\"id,cod,des\";",
"$$sel_whereString=\"id='\".$$clave.\"' AND cod LIKE 'A'\";",
"$$varray=iw_select_array($$tabla_principal,$$sel_fieldString,$$sel_whereString);"
],
"description": "iw_consulta_select_array_jbs"
},
"iw_consulta_select_while_jbs": {
"prefix": "iw_consulta_select_while_jbs",
"body": [
"## ${3:Comentarios}",
"\\$select_${1:xxxxxx} = \"SELECT * FROM ",
" ${2:nombre_tabla}",
" WHERE id = '\\$clave'\";",
"\\$result_${1:xxxxxx} = sql_query(\\$select_${1:xxxxxx},\\$dbi);",
"\\$nrows_${1:xxxxxx}=sql_num_rows(\\$result_${1:xxxxxx},\\$dbi);",
"if(\\$nrows_${1:xxxxxx}>0){",
" while(\\$v_${1:xxxxxx} = sql_fetch_array(\\$result_${1:xxxxxx}, \\$dbi)){",
" }",
"}",
]
},
"iw_consulta_update_jbs": {
"prefix": "iw_consulta_update_jbs",
"body": [
"$$upd_setString = \"cod='\".addslashes_jbs($$str_cod).\"', des='\".addslashes_jbs('ABC').\"'\";",
"$$upd_whereString = \"id='\".$$clave.\"'\";",
"if(!iw_update($$tabla_principal,$$upd_setString,$$upd_whereString)){",
" iweb_alerts(\"danger\",\"Adv.45: Problema al actualizar registro.\");",
" //echo \"@debug error: \". sql_error();",
"}"
],
"description": "iw_consulta_update_jbs"
},
"iw_consulta_select_tm_array_lista": {
"prefix": "iw_consulta_select_tm_array_lista",
"body": [
"## Lista ${4:YYY}",
"$$select_${1:XXXXX} = \"SELECT * FROM ${2:tabla} WHERE ${3:1}\";",
"$$result_${1:XXXXX} = sql_query($$select_${1:XXXXX},$$dbi);",
"while($$v_${1:XXXXX} = sql_fetch_array($$result_${1:XXXXX},$$dbi)){",
" $$list_${1:YYY}[$$v_${1:XXXXX}['id']] = $$v_${1:XXXXX}['des'];",
"}",
"$$list_${1:YYY}[0] = \"S/D\";",
]
},
"iw_consulta_insert_jbs": {
"prefix": "iw_consulta_insert_jbs",
"body": [
"$$ins_campos=\"id,id_connect,x_usr1,x_fec_usr1\";",
"$$ins_values=\"'\".addslashes_jbs($$clave).\"','\".addslashes_jbs($$id_connect).\"','\".addslashes_jbs($$x_usr1).\"','\".addslashes_jbs($$x_fec_usr1).\"'\";",
"$$result=iw_insert($$tabla_principal,$$ins_campos,$$ins_values,false);",
"if(!$$result){",
" //echo \"@debug error: \". sql_error();",
"}"
],
"description": "iw_consulta_insert_jbs"
},
"iw_consulta_delete_jbs": {
"prefix": "iw_consulta_delete_jbs",
"body": [
"$$upd_whereString=\"id='\".$$clave.\"'\";",
"$$result=iw_delete($$tabla_principal,$$upd_whereString,false);"
],
"description": "iw_consulta_delete_jbs"
},
"iw_funcion_actualizaParte": {
"prefix": "iw_funcion_actualizaParte",
"body": [
"$$parte_siguiente=2;",
"if(!iw_update_parte_jbs($$tabla_principal,$$clave,$$parte_siguiente,false)){",
" iweb_alerts(\"danger\",\"Adv.45: Problema al actualizar registro $$clave.\");",
" //echo \"@debug error: \". sql_error();",
"}"
],
"description": "iw_funcion_actualizaParte"
},
"iw_funcion_enviar_mail_jbs": {
"prefix": "iw_funcion_enviar_mail_jbs",
"body": [
"$$mensaje_comunicado=\"Mensaje comunicado al mail\";",
"if($$mensaje_comunicado!=\"\"){",
" $$subject_anexo=\"Tema JB - TEST MODIFICADOR\";",
" $$bool_auditaNotas=true;",
" iw_enviar_mail_jbs($$id_form,$$v,$$clave,$$usuarios_comunicar,$$array_mail,$$array_grupo_comunica,$$subject_anexo,$$mensaje_comunicado,$$bool_auditaNotas);",
"}"
],
"description": "iw_funcion_enviar_mail_jbs"
},
"iw_funcion_get_registro_jbs": {
"prefix": "iw_funcion_get_registro_jbs",
"body": [
"$$strCamposGet=\"id,id_connect,x_usr1,x_fec_usr1\";",
"$$cond_ad=\"\"; //\"AND cod='ABC'\";",
"$$v=iw_getRegistro($$tabla, $$clave, $$strCamposGet,$$cond_ad);"
],
"description": "iw_funcion_get_registro_jbs"
},
"iw_funcion_get_tabla_jbs": {
"prefix": "iw_funcion_get_tabla_jbs",
"body": [
"$$tabla_principal = iw_getTabla_jbs($$id_form);"
],
"description": "iw_funcion_get_tabla_jbs"
},
"iw_funcion_get_id_form_jbs": {
"prefix": "iw_funcion_get_id_form_jbs",
"body": [
"$$num_form=\"\"; //Nro formulario",
"$$tabla_principal=\"\"; //Tabla, si no sabemos el Nro formulario",
"$$id_form=iw_getIdForm_jbs($$tabla_principal, $$num_form);"
],
"description": "iw_funcion_get_id_form_jbs"
},
"iw_funcion_get_bloquea_jbs": {
"prefix": "iw_funcion_get_bloquea_jbs",
"body": [
"$$edita=2;",
"$$xbloqueado=iw_getBloquea_jbs($$id_form,$$edita);"
],
"description": "iw_funcion_get_bloquea_jbs"
},
"iw_funcion_get_NroParte_jbs": {
"prefix": "iw_funcion_get_NroParte_jbs",
"body": [
"$$xbloqueado=\"1:3:4:5\";",
"$$x_edita=iw_getNroParte_jbs($$id_form,$$xbloqueado);"
],
"description": "iw_funcion_get_NroParte_jbs"
},
"iw_funcion_hay_licencias_disponibles": {
"prefix": "iw_funcion_hay_licencias_disponibles",
"body": [
"iw_hayLicenciasDisponibles();"
],
"description": "iw_funcion_hay_licencias_disponibles"
},
"iw_funcion_calcula_sla_jbs": {
"prefix": "iw_funcion_calcula_sla_jbs",
"body": [
"if (!function_exists(\"calcula_sla_jbs\")) {",
" function calcula_sla_jbs($$id_form, $$parte, $$condicion, $$fecha_hora_base, $$calendario, $$dbi)",
" {",
" $$hs_no_laboral = 0;",
" $$dia_no_laboral_sumados = 0;",
" $$un_dia = 1;",
" $$where_condicion = \"\";",
" $$where_calendario = \"\";",
" ##Inicializo variables para que no tengan basura",
" if ($$condicion != \"\") {",
" $$where_condicion = \" AND condicion = '$$condicion' \";",
" } else {",
" $$where_condicion = \" AND condicion = '' \";",
" }",
" if ($$calendario != \"\") {",
" $$where_calendario = \" AND calendario = '$$calendario' \";",
" }",
" ## En string tenia form, traia puesto, no existe puesto en la tabla. ",
" $$sql_sla = \"SELECT hs",
" FROM nuke_iweb_sla_form_parte",
" WHERE form = '$$id_form' AND ",
" parte= '$$parte' ",
" $$where_condicion",
" $$where_calendario",
" LIMIT 0,1",
" \";",
" // echo \"sql sla:\".$$sql_sla;",
" $$res_sla = sql_query($$sql_sla, $$dbi);",
" $$filas = sql_num_rows($$res_sla, $$dbi); //$$filas = sql_num_rows($$res_puesto, $$dbi);",
" // echo \"<br />filas: $$filas<br />\";",
" if ($$filas > 0) {",
" $$fila = sql_fetch_array($$res_sla, $$dbi);",
" $$nuevafecha = date(\"Y-m-d H:i:s\", strtotime('+' . $$fila['hs'] . ' hour', strtotime($$fecha_hora_base)));",
" do {",
" // echo \"debug@ nueva fecha inicial: $$nuevafecha<br /> \";",
" ##Verifico la cantidad de dias no laborales entre fecha base y fecha nueva",
" $$sql_cal = \"SELECT 1",
" FROM nuke_iweb_calendario_det",
" WHERE calendario = $$calendario AND fechas >= '\" . substr($$fecha_hora_base, 0, 10) . \" 00:00:00' AND fechas <= '\" . substr($$nuevafecha, 0, 10) . \" 23:59:59'",
" \";",
" // echo \"<br />@debug 647 - $$sql_cal\";",
" $$res_cal = sql_query($$sql_cal, $$dbi);",
" $$filas_cal = sql_num_rows($$res_cal, $$dbi);",
" if ($$dia_no_laboral_sumados < $$filas_cal) {",
" $$cant_dias_adic = ($$filas_cal - $$dia_no_laboral_sumados);",
" $$nuevafecha = date(\"Y-m-d H:i:s\", strtotime('+' . ($$cant_dias_adic * 24) . ' hour', strtotime($$nuevafecha)));",
" $$dia_no_laboral_sumados += $$cant_dias_adic;",
" $$salir = true;",
" } else {",
" $$salir = false;",
" }",
" } while ($$salir);",
" ",
" return $$nuevafecha;",
" } else {",
" return $$fecha_hora_base;",
" }",
" }",
"}"
],
"description": "iw_funcion_calcula_sla_jbs"
},
"iw_funcion_script_control_radiobutton": {
"prefix": "iw_funcion_script_control_radiobutton",
"body": [
"## Control de muestreo de campos Fecha Finalización y Justificación Fecha (según Cambio Temporal) ",
"if($$vdatos['estado'] == 3 AND $$vdatos['fecha_finaudi'] == ''){",
" ## Si",
" $$inicio = \"",
" //$( \\\"input[name='fecha27']\\\" ).closest('tr').show();",
" $(\\\"input[name='fecha27']\\\").css({'background-color': 'red'});",
" $(\\\"input[name='add']\\\").prop('disabled', true); //Deshabilito el submit\";",
"}else{",
" ## No",
" $$inicio = \"",
" //$( \\\"input[name='fecha27']\\\" ).closest('tr').hide();",
" $(\\\"input[name='fecha27']\\\").css({'background-color': '#fff'});",
" $(\\\"input[name='add']\\\").prop('disabled', false); //Habilito el submit\"; ",
"}",
"",
"##Ocultado de campos Fecha de finalizacion y Justificacion Fecha, mediante radio button de Cambio Temporal",
"echo \"",
"<script type=\\\"text/javascript\\\">",
"",
"function controlFechaExpira(inicio){",
" var fecha_expira = $( \\\"input[name='fecha27']\\\").val();",
" var sel = $( \\\"input[name='rad11']:checked\\\" ).val();",
"",
" // Esto para detectar radio bottom cuando cambia de valor ",
" if(sel == 3 && fecha_expira == ''){",
" // Si (visualizamos campos Fecha)",
" // $( \\\"input[name='fecha27']\\\" ).closest('tr').show();",
" $(\\\"input[name='fecha27']\\\").css({'background-color': 'red'});",
" $(\\\"input[name='add']\\\").prop('disabled', true); //Deshabilito el submit ",
" ",
" }else{",
" // No (ocultamos campos Fecha)",
" // $( \\\"input[name='fecha27']\\\" ).closest('tr').hide();",
" $(\\\"input[name='fecha27']\\\").css({'background-color': '#fff'});",
" $(\\\"input[name='add']\\\").prop('disabled', false); //Habilito el submit",
" }",
"}",
"",
"$( document ).ready(function() {",
" var fecha_expira = $(\\\"input[name='fecha27']\\\").val();",
" var sel = $( \\\"input[name='rad11']\\\" ).val();",
" // console.log('@debug FECHA ' + fecha_expira + 'SELECTION ' + sel);",
" ",
" // Esto para detectar radio bottom cuando cambia de valor ",
" // Pongo por defecto",
" \".$$inicio.\"",
"",
" // Radio control completado de Fecha de Expiración ",
" $( \\\"input[type=radio][name='rad11']\\\" ).change(function() { ",
" controlFechaExpira(0);",
" });",
"",
" $(\\\"input[name='fecha27']\\\").change(function() { ",
" controlFechaExpira(0);",
" });",
" ",
" controlFechaExpira(1);",
"}); ",
"</script>\";"
],
"description": "script_control_radiobutton"
},
"iw_funcion_script_campos_obligatorios": {
"prefix": "iw_funcion_script_campos_obligatorios",
"body": [
"## INCLUDES DE QFORM",
"echo \"<SCRIPT SRC=\\\"\".$$GLOBALS['constante_url_site_cloud'].\"/includes/lib/qforms.js\\\"></SCRIPT>",
"<SCRIPT LANGUAGE=\\\"JavaScript\\\">",
"<!--//",
"// set the path to the qForms directory",
"qFormAPI.setLibraryPath(\\\"\".$$GLOBALS['constante_url_site_cloud'].\"/includes/lib/\\\");",
"// this loads all the default libraries",
"qFormAPI.include(\\\"*\\\");",
"//-->",
"",
"</SCRIPT>\";",
"## BLOQUE DE CODIGO PARA UTILIZAR EN",
"hash_iweb_form();",
"$$cf=\"<SCRIPT LANGUAGE=\\\"JavaScript\\\">",
"<!--//",
"// initialize the qForm object",
"objForm = new qForm(\\\"$$xform\\\");",
"// make these fields required",
"objForm.required(\\\"revnewid_form,newparte,newcantidad_vector,newnombre_archivo,newdirectorio_exporta\\\");",
"objForm.required_message_iweb('revnewid_form,newparte,newcantidad_vector,newnombre_archivo,newdirectorio',' \"._REPORTE.\", \"._DESCRIPCION.\", \"._EMITIR_CADA.\", \"._NOMBRE_ARCHIVO.\", \"._DIRECTORIO.\"-\"._EXPORTACION.\"');",
"//-->",
"</SCRIPT>\";",
"echo $$cf;"
],
"description": "iw_funcion_script_campos_obligatorios"
},
"iw_funcion_script_lov_ponPrefijoNueva": {
"prefix": "iw_funcion_script_lov_ponPrefijoNueva",
"body": [
"echo \"<script>",
" $(document).ready(function() {",
" if(typeof ponPrefijofields_${1:NombreCampoLOV}addatri === 'function'){",
" var oldSomeFunction = ponPrefijofields_${1:NombreCampoLOV}addatri;",
" ponPrefijofields_${1:NombreCampoLOV}addatri = function (a,b,c) {",
" oldSomeFunction(a,b,c);",
" // Nuevo código a ejecutar después de volver del lov",
" }",
" }",
" });",
" </script>\";",
]
},
"iw_funcion_script_f5_doble_submit": {
"prefix": "iw_funcion_script_f5_doble_submit",
"body": [
"echo \"<script>",
" function disableF5(e) { if ((e.which || e.keyCode) == 116 || (e.which || e.keyCode) == 82) e.preventDefault();};",
" $(document).ready(()=>{",
" $('#guardarBtn').click(function(){",
" $(document).on(\\\"keydown\\\", disableF5);",
" });",
" })",
" </script>\";",
"",
"echo \"<tr><td colspan=\\\"18\\\" align=\\\"center\\\">\n<input type=\\\"submit\\\" class=\\\"btn btn-default btn-sm\\\" $habili_cargar name=\\\"carga_tmp\\\" value=\\\"Ingresar\\\" id=\\\"guardarBtn\\\" onclick=\\\"this.value='En Proceso, Por Favor Espere';var e=this;setTimeout(function(){e.disabled=true;},0);return true;\\\"\\\">\";",
]
},
"iw_modificador_script_hide": {
"prefix": "iw_modificador_script_hide",
"body": [
"$(\\\"input[name='${1:nombre_campo}']\\\").closest(\\\"tr\\\").hide();",
]
},
"iw_modificador_script_show": {
"prefix": "iw_modificador_script_show",
"body": [
"$(\\\"input[name='${1:nombre_campo}']\\\").closest(\\\"tr\\\").show();",
]
},
"iw_modificador_script_optional": {
"prefix": "iw_modificador_script_optional",
"body": [
"objForm.optional(\\\"fields[CAMPO]\\\");",
"objForm.required(\\\"fields[CAMPO]\\\");",
]
},
"iw_modificador_script_readonly": {
"prefix": "iw_modificador_script_readonly",
"body": [
"$(\\\"input[name='CAMPO']\\\").attr(\\\"readonly\\\",true);",
]
},
"iw_funcion_diff_fechas_dias": {
"prefix": "iw_funcion_diff_fechas_dias",
"body": [
"## DIFERENCIA DE FECHAS - EN DIAS",
"## fin: FECHA MAYOR",
"## inicio: FECHA MENOR",
"function diferencia_fechas_dias($$inicio,$$fin){",
" $$segundos = strtotime($$fin) - strtotime($$inicio);",
" $$diferencia_dias = intval($$segundos/60/60/24);",
"",
" $$diferencia_dias++; ## Incluye ambas fechas límite",
"",
" return $$diferencia_dias;",
"}",
]
},
"iw_funcion_diff_fechas_hs": {
"prefix": "iw_funcion_diff_fechas_hs",
"body": [
"## DIFERENCIA DE FECHAS - EN HORAS",
"## END: FECHA MAYOR",
"## START: FECHA MENOR",
"function diferencia_fechas_hs($$end,$$start){",
"date_default_timezone_set('UTC');",
"if ($$end>$$start AND $$end!=\"\" AND $$start!=\"\"){",
"$$dif=strtotime($$end)-strtotime($$start);",
"$$dif_fec=floor($$dif/(3600));",
"}else{",
"$$dif_fec=\"0\"; ",
"}",
"date_default_timezone_set('America/Argentina/Buenos_Aires');",
"return ($$dif_fec);",
"}"
],
"description": "iw_funcion_php_diff_fechas_hs"
},
"iw_funcion_php_diff_fechas_hs_laboral": {
"prefix": "iw_funcion_php_diff_fechas_hs_laboral",
"body": [
"## ARRAY DE DIAS NO LABORALES - Verificamos que no sea feriado JB",
"$$sql_cal= \"SELECT fechas",
"FROM a0usr_f_018_sla_calendarios_det",
"WHERE calendario = '\".addslashes_jbs($$calendario).\"' AND fechas >= '\".$$hoy.\"'\";",
"// echo \"<br />@debug 647 - $$sql_cal\";",
"$$res_calnolaboral = sql_query($$sql_cal, $$dbi);",
"$$nrows_dias_no_laboral = sql_num_rows($$res_calnolaboral, $$dbi);",
"if($$nrows_dias_no_laboral>0){",
"$$lst_dianolaboral=array();",
"while($$vnolabora = sql_fetch_array($$res_calnolaboral, $$dbi)){",
"$$lst_dianolaboral[$$vnolabora['fechas']]=$$vnolabora['fechas'];",
"}",
"}",
"",
"## DIFERENCIA DE FECHAS - EN HORAS",
"## END: FECHA MAYOR",
"## START: FECHA MENOR",
"function diff_hs_laborales($$start, $$end){",
"",
"global $$lst_dianolaboral;",
" $$startDate = new DateTime($$start);",
" $$endDate = new DateTime($$end);",
" $$periodInterval = new DateInterval( \"PT1H\" );",
"",
" $$period = new DatePeriod( $$startDate, $$periodInterval, $$endDate );",
" $$count = 0;",
"",
" foreach($$period as $$date){",
"",
" $$startofday = clone $$date;",
" $$startofday->setTime(8,30);",
"",
" $$endofday = clone $$date;",
" $$endofday->setTime(17,30);",
"",
" if($$date > $$startofday && $$date <= $$endofday && !in_array($$date->format('l'), array('Sunday','Saturday')) && $$lst_dianolaboral[date_format($$date,\"Y-m-d\")] != date_format($$date,\"Y-m-d\")){",
"",
" $$count++;",
" }",
"",
" }",
" return $$count;",
"}"
],
"description": "iw_funcion_diff_fechas_hs_nolaboral"
},
"iw_funcion_php_control_adjuntos": {
"prefix": "iw_funcion_php_control_adjuntos",
"body": [
"$$parte=\"\";//\"1\"",
"$$tipo_archivo=\"\";//\"pdf\"",
"if(iw_cantidadDeAdjuntosEnRegistro_jbs($$id_form,$$clave,$$parte,$$tipo_archivo)<=0){",
" iweb_alerts(\"warning\",\"Se debe adjuntar al menos un documento.\");",
" $$parte_siguiente=2;",
" if(!iw_update_parte_jbs($$tabla_principal,$$clave,$$parte_siguiente,false)){",
" iweb_alerts(\"danger\",\"Adv.45: Problema al actualizar registro $$clave.\");",
" //echo \"@debug error: \". sql_error();",
" }",
"}"
],
"description": "iw_funcion_php_control_adjuntos"
},
"iw_funcion_php_dompdf_correo": {
"prefix": "iw_funcion_php_dompdf_correo",
"body": [
"//Datos de PDF, correo",
"$$str_html=\"<table align=\\\"center\\\" border=\\\"0\\\" width=\\\"95%\\\" style=\\\"margin-top:15px; margin-bottom:25px;\\\">\"; ",
"$$str_html.=\"<p style=\\\"LINE-HEIGHT:20px;\\\"><tr align=\\\"left\\\">\"; //bgcolor=\\\"#e9e9e9\\\"",
"$$str_html.=\"<td colspan=\\\"1\\\"><IMG SRC=\\\"$$nukeurl/images/logo_sh.jpg\\\" BORDER=\\\"0\\\" alt=\\\"\\\" BORDER=\\\"0\\\" width=\\\"60\\\" height=\\\"50\\\"></td>\";",
"$$str_html.=\"<td colspan=\\\"1\\\" align=\\\"right\\\"> </td>\";",
"$$str_html.=\"<td colspan=\\\"2\\\" align=\\\"right\\\"><b>Fecha:</b>\".$$fec_aprobacion[0].\" </td>\";",
"$$str_html.=\"</tr>\";",
"$$str_html.=\"<tr>\";",
"$$str_html.=\"<td align=\\\"center\\\" colspan=\\\"4\\\"><big><u>CLUSTER CONO SUR - FORMULARIO 1100</u></big></td>\";",
"$$str_html.=\"</tr>\";",
"$$str_html.=\"<tr>\";",
"$$str_html.=\"<td align=\\\"center\\\" colspan=\\\"4\\\"><big><u>INVERSIONES DE CAPITAL Y OTROS COMPROMISOS</u></big></td>\";",
"$$str_html.=\"</tr></p>\";",
"",
"$$str_html.=\"<p><tr align=\\\"center\\\">\"; ",
"$$str_html.=\"<td colspan=\\\"4\\\"> </td>\"; ",
"$$str_html.=\"</tr></p>\";",
" ",
"$$str_html.=\"<p><tr align=\\\"center\\\">\";",
"$$str_html.=\"<td colspan=\\\"4\\\"><b>|titulo </b></td>\";",
"$$str_html.=\"</tr>\";",
"$$str_html.=\"<tr align=\\\"left\\\">\"; ",
"$$str_html.=\"<td align=\\\"left\\\" colspan=\\\"2\\\"><b><i>Proponente: </i></b>\".$$User_iWebList[$$v[\"f1_proponente\"]][1].\"</td>\";",
"$$str_html.=\"<td align=\\\"right\\\" colspan=\\\"2\\\"><b><i>Numero de Propuesta de Inversión:</i></b>|id </td>\"; ",
"$$str_html.=\"</tr>\";",
"$$str_html.=\"<tr align=\\\"left\\\">\"; ",
"$$str_html.=\"<td align=\\\"left\\\" colspan=\\\"2\\\"><b><i>Indicador de Referencia: </i></b>|f1_indica_ref </td>\";",
"$$str_html.=\"<td align=\\\"right\\\" colspan=\\\"2\\\"><b><i>Categoría de la propuesta:</i></b>|clasifica_propuesta </td>\"; ",
"$$str_html.=\"</tr>\"; ",
"$$str_html.=\"<tr align=\\\"right\\\">\"; ",
"$$str_html.=\"<td colspan=\\\"2\\\"> </td>\";",
"$$str_html.=\"<td colspan=\\\"2\\\"><b><i>VIR:</i></b>|vir7 </td>\"; ",
"$$str_html.=\"</tr>\"; ",
"$$str_html.=\"<tr align=\\\"right\\\">\"; ",
"$$str_html.=\"<td colspan=\\\"2\\\"> </td>\";",
"$$str_html.=\"<td colspan=\\\"2\\\"><b><i>Thread ID:</i></b>|threat_id </td>\"; ",
"$$str_html.=\"</tr></p>\"; ",
"",
"$$str_html.=\"<p><tr align=\\\"center\\\">\"; ",
"$$str_html.=\"<td colspan=\\\"4\\\"> </td>\"; ",
"$$str_html.=\"</tr></p>\";",
" ",
"$$str_html.=\"<p><tr align=\\\"left\\\">\";",
"$$str_html.=\"<td colspan=\\\"4\\\"><b><i>Alcance de la Solución Propuesta:</i></b></td>\";",
"$$str_html.=\"</tr>\";",
"$$str_html.=\"<tr align=\\\"left\\\">\";",
"$$str_html.=\"<td colspan=\\\"4\\\">|f1_alcance_sol </td>\";",
"$$str_html.=\"</tr>\"; ",
"$$str_html.=\"<tr align=\\\"left\\\">\";",
"$$str_html.=\"<td colspan=\\\"4\\\"><b><i>Justificación:</i></b></td>\";",
"$$str_html.=\"</tr>\";",
"$$str_html.=\"<tr align=\\\"left\\\">\";",
"$$str_html.=\"<td colspan=\\\"4\\\">|f1_des_propuesta </td>\";",
"$$str_html.=\"</tr></p>\"; ",
"",
"$$str_html.=\"<p><tr align=\\\"center\\\">\"; ",
"$$str_html.=\"<td colspan=\\\"4\\\"> </td>\"; ",
"$$str_html.=\"</tr></p>\";",
" ",
"$$str_html.=\"<p><tr align=\\\"left\\\" bgcolor=\\\"#e9e9e9\\\"><td colspan=\\\"4\\\"><b>PROPUESTA DE INVERSIÓN</b></td></tr>\"; ",
"$$str_html.=\"<tr align=\\\"center\\\" bgcolor=\\\"#e9e9e9\\\">\";",
"$$str_html.=\"<td colspan=\\\"1\\\" rowspan=\\\"2\\\"><b>Inversión</b></td>\";",
"$$str_html.=\"<td colspan=\\\"1\\\" rowspan=\\\"2\\\"><b>TOTAL U$$S</b></td>\"; ",
"$$str_html.=\"<td colspan=\\\"2\\\" bgcolor=\\\"#e9e9e9\\\"><b>Años Estimados de Inversión</b></td>\";",
"$$str_html.=\"</tr>\";",
"$$str_html.=\"<tr align=\\\"center\\\"><td colspan=\\\"1\\\"><b>Año en curso</b></td>\";",
"$$str_html.=\"<td colspan=\\\"1\\\"><b>Año siguiente</b></td></tr>\"; ",
"$$str_html.=\"<tr align=\\\"left\\\">\";",
"$$str_html.=\"<td bgcolor=\\\"#e9e9e9\\\"><b>Capitalizable (Sin IVA)</b></td>\";",
"$$str_html.=\"<td align=\\\"center\\\">$$tot_ku_c</td>\";",
"$$str_html.=\"<td align=\\\"center\\\">$$anio_1_c</td>\";",
"$$str_html.=\"<td align=\\\"center\\\">$$anio_2_c</td>\";",
"$$str_html.=\"</tr>\";",
"$$str_html.=\"<tr align=\\\"left\\\">\";",
"$$str_html.=\"<td bgcolor=\\\"#e9e9e9\\\"><b>No Capitalizable (Sin IVA)</b></td>\";",
"$$str_html.=\"<td align=\\\"center\\\">$$tot_ku_nc</td>\";",
"$$str_html.=\"<td align=\\\"center\\\">$$anio_1_nc</td>\";",
"$$str_html.=\"<td align=\\\"center\\\">$$anio_2_nc</td>\";",
"$$str_html.=\"</tr>\";",
"$$str_html.=\"<tr align=\\\"left\\\">\";",
"$$str_html.=\"<td bgcolor=\\\"#e9e9e9\\\"><b>Total a autorizar (A+B+IVA de A+B)</b></td>\";",
"$$str_html.=\"<td align=\\\"center\\\">$$t_total_ku</td>\";",
"$$str_html.=\"<td align=\\\"center\\\">$$t_anio_1</td>\";",
"$$str_html.=\"<td align=\\\"center\\\">$$t_anio_2</td>\";",
"$$str_html.=\"</tr></p>\";",
"",
"$$str_html.=\"<p><tr align=\\\"center\\\">\"; ",
"$$str_html.=\"<td colspan=\\\"4\\\"> </td>\"; ",
"$$str_html.=\"</tr></p>\";",
"",
"$$str_html.=\"<p><tr>\";",
"$$str_html.=\"<td colspan=\\\"4\\\"><b><i>Fecha de Finalización mecánica: </i></b>|fec_finaliza </td>\";",
"$$str_html.=\"</tr></p>\";",
"",
"$$str_html.=\"<p><tr align=\\\"center\\\">\"; ",
"$$str_html.=\"<td colspan=\\\"4\\\"> </td>\"; ",
"$$str_html.=\"</tr></p>\";",
"",
"$$str_html.=\"<p><tr align=\\\"left\\\">\";",
"$$str_html.=\"<td colspan=\\\"4\\\"><b><i>Datos Adicionales:</i></b></td>\";",
"$$str_html.=\"</tr>\";",
"$$str_html.=\"<tr align=\\\"left\\\">\";",
"$$str_html.=\"<td colspan=\\\"4\\\">|f1_datos_adicional </td>\";",
"$$str_html.=\"</tr></p>\"; ",
"",
"$$str_html.=\"<p><tr align=\\\"center\\\">\"; ",
"$$str_html.=\"<td colspan=\\\"4\\\"> </td>\"; ",
"$$str_html.=\"</tr></p>\";",
" ",
"$$str_html.=\"<p><tr align=\\\"left\\\">\";",
"$$str_html.=\"<td colspan=\\\"1\\\">\".$$User_iWebList[$$v[\"f1_proponente\"]][1].\"</td>\";",
"$$str_html.=\"<td colspan=\\\"1\\\">\".$$User_iWebList[$$v[\"de_p3\"]][1].\"</td>\";",
"$$str_html.=\"<td colspan=\\\"1\\\">\".$$User_iWebList[$$v[\"f1_confirmante\"]][1].\"</td>\";",
"$$str_html.=\"<td colspan=\\\"1\\\">\".$$User_iWebList[$$v[\"f1_autorizante\"]][1].\"</td>\";",
"$$str_html.=\"</tr>\";",
"",
"$$str_html.=\"<tr align=\\\"left\\\">\";",
"$$str_html.=\"<td colspan=\\\"1\\\">____________________</td>\";",
"$$str_html.=\"<td colspan=\\\"1\\\">____________________</td>\";",
"$$str_html.=\"<td colspan=\\\"1\\\">____________________</td>\";",
"$$str_html.=\"<td colspan=\\\"1\\\">____________________</td>\";",
"$$str_html.=\"</tr>\"; ",
"$$str_html.=\"<tr align=\\\"left\\\">\";",
"$$str_html.=\"<td colspan=\\\"1\\\">PROPONENTE</td>\";",
"$$str_html.=\"<td colspan=\\\"1\\\">DE/EJECUTANTE</td>\";",
"$$str_html.=\"<td colspan=\\\"1\\\">CONFIRMANTE</td>\";",
"$$str_html.=\"<td colspan=\\\"1\\\">AUTORIZANTE</td>\";",
"$$str_html.=\"</tr></p>\";",
" ",
"$$str_html.=\"</table>\";",
" ",
"$$str_html = Carga_Datos_Text($$id_form,$$v,$$str_html,\"|\"); ",
"$$mensaje_comunicado_file = \"\\n $$str_html\"; ",
"",
"## Abrimos el archivo para introducir HTML",
"$$archivo = \"F1100_\".date(\"ymdhm\").\"_\".$$id_form.\"_\".$$clave.\"\";",
"$$archivohtml = $$archivo.\".pdf\";",
"$$path = $$GLOBALS[\"constante_directorio_file\"].\"/files_adjuntos/$$archivohtml\";",
"$$fw = fopen(\"$$path\", \"w\") or die(\"No se puede abrir el archivo!\");",
"## Escribimos el archivo",
"fwrite($$fw, $$mensaje_comunicado_file);",
"fclose($$fw); ",
"",
"## Ejecutamos libreria para estructurar el PDF a partir del archivo HTML",
"require_once($$constante_directorio_site.\"/modules/usr_usr_pro_inversion/dompdf-0.6.1/dompdf_config.inc.php\"); //usr_ (Agregar en Shell)",
"// echo \"<br />PDF: $$constante_directorio_site\";",
"",
"// error_reporting(E_ALL);",
"// ini_set(\"display_errors\", 1);",
" ",
"def(\"DOMPDF_ENABLE_REMOTE\", true);",
"$$mipdf = new DOMPDF(); ",
"# Definimos el tamaño y orientación del papel que queremos.",
"# O por defecto cogerá el que está en el fichero de configuración.",
"$$mipdf ->set_paper(\"A4\", \"portrait\");",
"# Cargamos el contenido HTML.",
"$$mipdf ->load_html(utf8_encode($$str_html));",
"# Renderizamos el documento PDF.",
"$$mipdf ->render();",
"# Guardamos el archivo para luego poder adjuntarlo",
"$$path = $$GLOBALS[\"constante_directorio_file\"].\"/files_adjuntos/$$archivo.pdf\";",
"// echo \"<br />\".$$str_html;",
"$$file_to_save = $$path;",
"//save the pdf file on the server",
"file_put_contents($$file_to_save, $$mipdf->output()); ",
"//print the pdf file to the screen for saving",
"// header(\"Content-type: application/pdf\");",
"// header(\"Content-Disposition: inline; filename=\".$$archivo.\".pdf\");",
"// header(\"Content-Transfer-Encoding: binary\");",
"// header(\"Content-Length: \" . filesize($$file_to_save));",
"// header(\"Accept-Ranges: bytes\");",
"// readfile($$file_to_save);",
"// $$fw = fopen(\"$$path\", \"w\") or die(\"No se puede abrir el archivo!\");",
"// ## Escribimos el archivo",
"// fwrite($$fw, $$mipdf);",
"// fclose($$fw); ",
"",
"## Adjuntamos el archivo HTML al registro",
"$$file1_name=urlencode($$archivo);",
"$$file1_name=base64_encode(serialize($$file1_name)).\".pdf\";",
"$$detalle_problem=\"\";",
"",
"if(file_exists($$path)){",
" $$sql = \"INSERT INTO \"._IW_SGC_FORMULARIOS_FILES.\"",
" (id, xfec_alta, xuser_connect, id_form, id_ot, url, name, date, elaboro, parte)",
" VALUES ",
" ('','$$ahora','1','$$id_form','$$clave','$$file1_name','$$archivo.pdf', '$$ahora', '1', '1')\";",
" // echo \"<br>Hola 63 $$sql\";",
" if(!sql_query($$sql, $$dbi) == 1){",
" iweb_alerts(\"danger\",\"<b>Adv. 1156: Al agregar encabezado de archivo adjunto</b>\");",
" }else{",
" $$xfieldname=\"id\";",
" $$numero=sql_id($$dbi,_IW_SGC_FORMULARIOS_FILES,$$xfieldname);",
" $$file1_name=\"$$numero\".$$file1_name; ",
" if(copy(\"$$constante_directorio_file/files_adjuntos/$$archivo.pdf\",\"$$constante_directorio_file/files_registracion/$$file1_name\")){",
"// unlink(\"$$constante_directorio_file/files_importacion/$$archivo\");",
" $$sql = \"UPDATE \"._IW_SGC_FORMULARIOS_FILES.\" ",
" SET url=\".$$file1_name.\"",
" WHERE id=\".$$numero.\"\";",
" // echo \"<br>Hola 1786 $$sql\";",
" if(!sql_query($$sql, $$dbi) == 1){",
" iweb_alerts(\"danger\",\"<b>Adv. 1169: Modificar URL en la carga del adjunto</b>\");",
" }else{",
" /**LOG cargado correctamente*/",
" } ",
" }else{",
" iweb_alerts(\"danger\",\"<b>Adv. 1175: En la carga del archivo HTML(tiempo de traspaso)</b>\");",
" } ",
" }",
"}",
"",
"## Comunicamos a usuario seleccionado para la Ejecución ",
"$$array_mail[$$v[\"resp_ejecucion\"]] = $$User_iWebList[$$v[\"resp_ejecucion\"]][2];",
"require_once(\"includes/mail/PHPMailerAutoload.php\");",
"",
"## SELECT USUARIOS X SECTOR - A Comunicar",
"$$select_usrsec = \"SELECT usuario",
" FROM a0usr_sh_pro_inversion_eys",
" WHERE 1\";",
"// echo \"<br>@debug USRSEC $$select_usrsec \";",
"$$result_usrsec = sql_query($$select_usrsec,$$dbi);",
"$$nrows_usrsec = sql_num_rows($$result_usrsec,$$dbi);",
"if($$nrows_usrsec>0){",
" while ($$v_usrsec = sql_fetch_array($$result_usrsec, $$dbi)){",
" $$array_mail[$$v_usrsec[\"usuario\"]]=$$User_iWebList[$$v_usrsec[\"usuario\"]][2];",
" }",
"} ",
" ",
"#Traigo los nombres de adjuntos en campo evidencias separados por \\n ;",
"$$whereString_file=\"\";",
"$$whereString_file.=\"name LIKE '\".addslashes_jbs($$archivohtml).\"'\"; ",
" $$mensaje_comunicado_ff = \"Se ha realizado la Aprobación F1100 con los datos que encontrará en el PDF adjunto.\";",
"",
"$$encabezado = $$sitename;",
"$$titulo = \"iWF | Propuesta de Inversión Digital\";",
"$$href = \"$$nukeurl/modules.php?name=sgc_registracion&file=genera2&registro=$$clave&do=presentaform2&id_form=$$id_form&xmenu=$$xmenu\";",
"$$link = hash_iweb_encode_url($$href);",
"$$descripcion_link = \"Link al registro\";",
"$$footer = \"Recuerde estar logueado en previamente en iWeb\";",
"$$texto_alternativo = \"J&B Solutions\";",
"",
"$$content = iweb_mail_template($$titulo,$$encabezado,$$mensaje_comunicado_ff,$$link,$$descripcion_link,$$footer,$$texto_alternativo);",
"",
"## Comunicación a Usuarios con adjuntos ",
"if($$mensaje_comunicado_ff != \"\" AND count($$array_mail) > 0){",
" $$mail = new PHPMailer;",
" ",
" ## Destinatarios",
" if(count($$array_mail)>0){",
" foreach($$array_mail as $$destinatario){",
"// $$destinatario = \"ez@jbsolutions.com.ar\";",
" $$mail->addAddress($$destinatario);",
" $$emails_call .= \"<br /> $$destinatario\";",
" }",
" }",
" ",
" ## De parte de",
" $$from_address=$$connect_email;",
" $$mail->setFrom($$from_address,$$nom);",
" ",
" ## Asunto ",
" $$subject = \"[iWF] Propuesta de Inversión Nro. $$clave\";",
" $$mail->Subject = $$subject;",
" ",
" ## Cuerpo y contenido mail",
" ## Adjuntos",
" $$mail->isHTML(true);",
" ",
" $$select_adjunto = \"SELECT url, name ",
" FROM nuke_sgc_formularios_files ",
" WHERE id_form = \".$$id_form.\" AND id_ot=\".$$clave.\" AND ($$whereString_file)",
" ORDER BY id DESC",
" LIMIT 0,1\";",
" $$res_adjunto = sql_query($$select_adjunto, $$dbi); ",
"// echo \"<br />@debug SEL: $$select_adjunto\";",
" ",
" if(sql_num_rows($$res_adjunto, $$dbi) > 0){",
" while($$v_adjunto = sql_fetch_array($$res_adjunto, $$dbi)){",
" ##Nombre y extensión en el adjunto cargado",
" $$nombre_archivo = $$v_adjunto[\"name\"];",
" $$v_codif_ext=explode(\".\",$$v_adjunto[\"url\"]);",
" $$extension = $$v_codif_ext[1];",
" ",
" ##Nombre y extensión en el adjunto cargado",
" $$url_adjunto = \"$$constante_directorio_file/files_registracion/\".$$v_adjunto[\"url\"]; ",
" $$alt_adjunto = \"Se envía adjunto un archivo.\";",
" $$mail->AddAttachment($$url_adjunto, $$nombre_archivo); ",
" }",
" } ",
"// echo \"<br />\".$$mensaje_comunicado_ff;",
" $$mail->Body = $$content; ",
" $$error=\"\";",
" ",
" OpenDivMascara();",
"// $$mail = \"ez@jbsolutions.com.ar\";",
"// $$emails_call = \"ez@jbsolutions.com.ar\"; ",
" if($$mail->Send_jbs()){ ",
" echo \"<tr><td><IMG SRC=\\\"images/sgc/f_hot.gif\\\" BORDER=\\\"0\\\" alt=\\\"No enviado problemas de conexion con el servidor de destino\\\"> <b>No enviado, problemas de conexión con el servidor de destino</b></td></tr>\"; ",
" }else{",
" echo \"<tr><td><IMG SRC=\\\"images/sgc/f_poll.gif\\\" BORDER=\\\"0\\\" alt=\\\"Enviado\\\"> <b>Mensaje enviado y comunicado a: </b>$$emails_call<br></td></tr>\";",
" }",
" ",
" CloseDivMascara();",
" }"
],
"description": "iw_funcion_php_pdf_dom_correo"
},
"iw_funcion_convertir_bytes": {
"prefix": "iw_funcion_convertir_bytes",
"body": [
"function convertir_bytes_en($$bytes, $$to, $$decimal_places = 1) {",
" $$formulas = array(",
" 'K' => number_format($$bytes / 1024, $$decimal_places),",
" 'M' => number_format($$bytes / 1048576, $$decimal_places),",
" 'G' => number_format($$bytes / 1073741824, $$decimal_places)",
" );",
" return isset($$formulas[$$to]) ? $$formulas[$$to] : 0;",
"}"
],
"description": "iw_funcion_convertir_bytes"
},
"iw_modificador_php_body": {
"prefix": "iw_modificador_php_body",
"body": [
"<?php",
"",
"",
"",
"?>"
]
},
"iw_modificador_php_if_genera": {
"prefix": "iw_modificador_php_if_genera",
"body": [
"if($$vmh==\"sgc_registracion-${1|genera1,genera2,genera_hijo|}\"){",
"",
"}"
],
"description": "iw_php_if_genera"
},
"iw_modificador_alert": {
"prefix": "iw_modificador_alert",
"body": [
"iweb_alerts(\"${1|info,success,warning,danger|}\",\"${2:MENSAJE}\");",
]
},
"iw_modificador_user_list_jbs": {
"prefix": "iw_modificador_user_list_jbs",
"body": [
"##[0]=['uname'][1]=['name'][2]=['email'][3]=['user_viewemail']",
"$$User_iWebList[$$id_connect][${1|0,1,2,3|}]"
],
"description": "iw_modificador_user_list_jbs"
},
"iw_modificador_addslashes_jbs": {
"prefix": "iw_modificador_addslashes_jbs",
"body": [
"addslashes_jbs();",
],
"description": "iw_modificador_addslashes_jbs"
},
"iw_modificador_carga_datos_text": {
"prefix": "iw_modificador_carga_datos_text",
"body": [
"Carga_Datos_Text($$id_form, $$v, $$texto, $$caracter_clave);"
],
"description": "iw_modificador_carga_datos_text"
},
"iw_modificador_carga_datos_text_hijo": {
"prefix": "iw_modificador_carga_datos_text_hijo",
"body": [
"Carga_Datos_Text_Hijo($$id_reg_padre, $$id_form_hijo, $$campo_vincula, $$campos_lista, $$caracter_separador);"
],
"description": "iw_modificador_carga_datos_text"
},
"iw_modificador_carga_etiqueta_text": {
"prefix": "iw_modificador_carga_etiqueta_text",
"body": [
"Carga_Etiqueta_Text($$id_form, $$texto, $$caracter_clave);"
],
"description": "iw_modificador_carga_etiqueta_text"
},
"iw_modificador_carga_def_form": {
"prefix": "iw_modificador_carga_def_form",
"body": [
"Carga_Def_Form($$id_form);"
],
"description": "iw_modificador_carga_def_form"
},
"iw_modificador_notification": {
"prefix": "iw_modificador_notification",
"body": [
"iweb_notification($$posicion, $$tipo_alerta, $$mensaje_informado, $$estilo, $$estado_cierre);"
],
"description": "iw_modificador_notification"
},
"iw_modificador_debug": {
"prefix": "iw_modificador_debug",
"body": [
"echo \"<br><b>@debug</b> - ${1:variable}: $${1:variable}\";",
]
},
"iw_modificador_ahora": {
"prefix": "iw_modificador_ahora",
"body": [
"$$ahora = date('Y-m-d H:i:s');",
]
},
"iw_modificador_hoy": {
"prefix": "iw_modificador_hoy",
"body": [
"$$hoy = date('Y-m-d');",
]
},
"iw_modificador_br": {
"prefix": "iw_modificador_br",
"body": [
"echo \"<br>\";",
]
},
"iw_modificador_if_multiparte": {
"prefix": "iw_modificador_if_multiparte",
"body": [
"if($$v['x_edita'] == '1'){",
"## Sentencias a ejecutarse al guardar parte 1",
"",
" if($$v['ESTADO_INICIO'] == NRO_ESTADO){",
" ## Finalizada - avanzamos a parte 2",
" $$parte_siguiente=2;",
" }else{",
" ## Pendiente - retenemos en parte 1",
" $$parte_siguiente=1;",
" }",
"",
"}elseif($$v['x_edita'] == '2'){",
"## Sentencias a ejecutarse al guardar parte 2",
"",
" if($$v['ESTADO_CIERRE'] == NRO_ESTADO){",
" ## Finalizada - Cerramos",
" $$parte_siguiente=3;",
" }else{",
" ## Pendiente - retenemos en parte 2",
" $$parte_siguiente=2;",
" }",
"",
"}",
"if(!iw_update_parte_jbs($$tabla_principal,$$clave,$$parte_siguiente,false)){",
" iweb_alerts(\"danger\",\"Adv.45: Problema al actualizar registro $$clave.\");",
" //echo \"@debug error: \". sql_error();",
"}"
],
"description": "iw_modificador_if_multiparte"
},
"iw_modificador_foreach": {
"prefix": "iw_modificador_foreach",
"body": [
"echo \"<br>@debug - ${1:nombre_vector}:\";",
"foreach($${1:nombre_vector} as $${2:key} => $${3:value}){",
" echo \"<br>@debug - {2:key}: $${2:key} ; {3:value}: $${3:value}\";",
"}",
]
},
"iw_modificador_id_nuevo": {
"prefix": "iw_modificador_id_nuevo",
"body": [
"$${1:id_registro} = sql_id($$dbi,'${2:tabla}','id');",
]
},
"iw_modificador_link_editar_registro": {
"prefix": "iw_modificador_link_editar_registro",
"body": [
"## Link a XXX",
"$${1:link} = \"$$nukeurl/modules.php?name=sgc_registracion&file=genera2&registro=$$clave&do=presentaform2&id_form=$$id_form&xmenu=$$xmenu\";",
"$${2:link_encode} = hash_iweb_encode_url($${1:link});",
"$$href = \"<a href = \\\"$${2:link_encode}\\\" target = \\\"_blank\\\">${3:DESCRIPCION_LINK}</a>\";",
"echo \"$$href\";",
]
},
"iw_modificador_link_alta_registro": {
"prefix": "iw_modificador_link_alta_registro",
"body": [
"## Link a alta registro ${1:XXX}",
"$$link = \"$$nukeurl/modules.php?op=modload&name=sgc_xmuestra&vemos=form&getfile=${2:nombre_form}&xmenu=${3:nro_menu}\";",
"$$link_encode = hash_iweb_encode_url($$link);",
"$$href = \"<a href = \\\"$$link_encode\\\" target = \\\"_blank\\\"><i class=\\\"fa fa-link\\\" aria-hidden=\\\"true\\\"></i> Link a ${1:XXX}</a>\";",
"echo \"$$href\";",
]
},
"iw_modificador_nueva_nota_iweb": {
"prefix": "iw_modificador_nueva_nota_iweb",
"body": [
"## Guardado de nota en comentarios anexos con formato estándar",
"$$texto = \"$comunicacion_enviada\";",
"$$ahora = date('Y-m-d H:i:s');",
"$$tabla = $$table_form;",
"$$orden = \"ASC\";",
"$$campo = \"xcoment_anexo\";",
"// nueva_nota_iweb(addslashes_jbs($texto),$id_connect,$ahora,$tabla,$clave); ## Sin orden y son campo, por defecto es orden ascendente y en el campo xcoment_anexo",
"if(!nueva_nota_iweb(addslashes_jbs($$texto),$$id_connect,$$ahora,$$tabla,$$clave,$$orden,$$campo)){",
" ## Si la nota NO se guardó correctamente",
" iweb_alerts(\"danger\",\"<b>¡Campo notas no fue auditado!</b>\");",
"}",
]
},
"iw_modificador_script": {
"prefix": "iw_modificador_script",
"body": [
"?>",
"<script>",
" $(document).ready(function(){",
" ",
" });",
" </script>",
"<?php"
],
"description": "iw_modificador_script"
},
"iw_modificador_debug_error": {
"prefix": "iw_modificador_debug_error",
"body": [
"ini_set('display_errors', 1);",
"ini_set('display_startup_errors', 1);",
"error_reporting(E_ALL);",
]
},
"iw_modificador_encabezado_jbs": {
"prefix": "iw_modificador_encabezado_jbs",
"body": [
"/**",
"* @file ${1:FILENAME}",
"*",
"* ${2:A summary MASCARA informing the user what the associated element does}.",
"*",
"*",
"* @version 4.0.0 ${3:AAAA-MM-DD} | Autor : ${4:NOMBRE_AUTOR}. Se creó el modificador",
"*",
"* @copyright J&B Solutions SA",
"*/",
"",
"",
""
]
},
"iw_modificador_cfa": {
"prefix": "iw_modificador_cfa",
"body": [
"$$cf_a['CAMPO'] .= \"\";",
]
},
"iw_modificador_cfa_dibujo_fila": {
"prefix": "iw_modificador_iw_modificador_cfa_dibujo_fila",
"body": [
"$$cf_a['CAMPO'] .= \"<tr bgcolor = \\\"#D5D5D5\\\" class = \\\"sgc_parteX\\\"><td colspan = \\\"2\\\"></td></tr>\";",
]
},
"iw_modificador_volver_cf": {
"prefix": "iw_modificador_volver_cf",
"body": [
"## Link a Modificar parte anterior",
"$$link = \"$$nukeurl/modules.php?name=sgc_registracion&file=genera2&registro=$$clave&do=presentaform2&id_form=$$id_form&xmenu=$$xmenu&retro=1:2:3:4:5\";",
"$$link_encode = hash_iweb_encode_url($$link);",
"$$href = \"<a href = \\\"$$link_encode\\\">Modificar parte 1</a>\";",
"$$cf_a['estado_incidente'] .= \"<tr><td></td><td><img src=\\\"images/sgc/116.gif\\\" border=\\\"0\\\" width=\\\"20\\\">$$href</td></tr>\";",
]
},
"iw_modificador_variables_hijo": {
"prefix": "iw_modificador_variables_hijo",
"body": [
"$$no_veo_clonacion = \"S\";",
"$$no_veo_edita_en_linea = \"S\";",
"$$no_veo_edita_en_formulario = \"S\";",
"$$vec_borra[$v['id']] = $v['id']; ## Vector con los ids que SI puedo borrar",
"$$vec_borra[0] = 0; ## O seteo este valor si no puedo borrar ninguno",
]
},
"iw_modificador_define": {
"prefix": "iw_modificador_define",
"body": [
"define(\"_VARIABLE\",\"TEXTO\");",
]
},
"iw_modificador_lenguaje": {
"prefix": "iw_modificador_lenguaje",
"body": [
"iw_lenguaje_form_mod($$id_form,_VARIABLE)",
]
},
"iw_modificador_calcula_fecha": {
"prefix": "iw_modificador_calcula_fecha",
"body": [
"$$fecha_calculada = date('Y-m-d',mktime(0,0,0,$$mes,$$dia,$$anio)); ## Puedo poner +N o -N en el parámetro al que quiero sumar/restar",
]
},
"iw_modificador_funcion": {
"prefix": "iw_modificador_funcion",
"body": [
"if(!function_exists('nombre_funcion')){",
" function nombre_funcion(){",
" ",
" }",
"}",
]
},
"iw_modificador_usuarios_gf": {
"prefix": "iw_modificador_usuarios_gf",
"body": [
"$$select_usuarios = \"SELECT * FROM nuke_users WHERE conjfun IN (SELECT id_conjunto FROM nuke_sgc_conj_grupos WHERE id_grupo = '$$id_grupo_funcional')\";",
"## el $gf_parte puede ser una subconsulta de el/los ids de gf:",
"## id_grupo IN (SELECT id_grupo FROM nuke_sgc_gruposf WHERE cod_grupo IN ('COD-GF1','COD-GF2'))",
"$$res_usuarios = sql_query($$select_usuarios,$$dbi);",
"$$nrows_usuarios = sql_num_rows($$res_usuarios,$$dbi);",
"",
"if($$nrows_usuarios > 0){",
" while($$v_usuario = sql_fetch_array($$res_usuarios,$$dbi)){",
" ## acciones a realizar con los usuarios",
" }",
"}",
]
},
"iw_modificador_prebu_condicion": {
"prefix": "iw_modificador_prebu_condicion",
"body": [
"$$def_wher_pre_buscar = \" AND ${1:campo_formulario} = '$$id_connect'\";",
]
},
"iw_modificador_variables_debug": {
"prefix": "iw_modificador_variables_debug",
"body": [
"$$sql_debug_pb = \"S\";",
"## $$debug_sql_repo = \"S\";",
]
},
"iw_modificador_setteo": {
"prefix": "iw_modificador_setteo",
"body": [
"if(!isset(${1:$variable})) ${1:$variable} = ${2:valor};",
]
},
"iw_modificador_hidden": {
"prefix": "iw_modificador_hidden",
"body": [
"echo \"<input type=\\\"hidden\\\" name=\\\"${1:$variable}\\\" value=\\\"$${1:$variable}\\\">\";",
]
},
"iw_modificador_font_awesome": {
"prefix": "iw_modificador_font_awesome",
"body": [
"<i class=\\\"fa fa-NOMBRE\\\" aria-hidden=\\\"true\\\"></i>",
]
},
"iw_modificador_condicion_lov": {
"prefix": "iw_modificador_condicion_lov",
"body": [
"## Condición sobre campo lov",
"$$cf_condicion['campo_condicion'] = \" AND campo = ''\";",
]
},
"iw_modificador_script_control_radio_obligatorios": {
"prefix": "iw_modificador_script_control_radio_obligatorios",
"body": [
"$('#guardar_iweb').closest('td').append('<span id=\\\"save_disabled\\\" style=\\\"color:red\\\"><br>  Tiene pregunta/s sin contestar.</span>');",
" ",
" $('#guardar_iweb').prop('disabled', true); //Deshabilito el submit ",
" $('#guardar_iweb_final').prop('disabled', true); //Deshabilito el submit ",
" $('#save_disabled').show(); //Muestro advertencia de completar campos obligatorios",
"",
" $(\\\".radio\\\").on('change keyup paste mouseup', function() { ",
" var estado_fibras_rad = $( \\\"input[name='rad28']:checked\\\" ).val(); ",
" var estado_costuras_rad = $( \\\"input[name='rad13']:checked\\\" ).val();",
" var estado_partes_metalicas_rad = $( \\\"input[name='rad17']:checked\\\" ).val();",
" var quemaduras_quimicos_rad = $( \\\"input[name='rad16']:checked\\\" ).val();",
" var cabo_vida_mosquetones_rad = $( \\\"input[name='rad14']:checked\\\" ).val();",
" var absorbedor_impacto_rad = $( \\\"input[name='rad38']:checked\\\" ).val();",
" var doble_seguro_rad= $( \\\"input[name='rad39']:checked\\\" ).val();",
" var estado_mosqueton_rad = $( \\\"input[name='rad35']:checked\\\" ).val(); ",
" var fibras_cabo_vida_rad = $( \\\"input[name='rad43']:checked\\\" ).val();",
" var flexibilidad_cabo_vida_rad = $( \\\"input[name='rad44']:checked\\\" ).val();",
" var cortes_cabo_vida_rad = $( \\\"input[name='rad29']:checked\\\" ).val(); ",
" ",
" if( estado_fibras_rad == '0' || estado_costuras_rad == '0' || estado_partes_metalicas_rad == '0' || quemaduras_quimicos_rad == '0' || cabo_vida_mosquetones_rad == '0' || absorbedor_impacto_rad == '0' || doble_seguro_rad == '0' || estado_mosqueton_rad == '0' || ",
" fibras_cabo_vida_rad == '0' || flexibilidad_cabo_vida_rad == '0' || cortes_cabo_vida_rad == '0'",
" ",
" ){",
" $('#guardar_iweb').prop('disabled', true); //Deshabilito el submit ",
" $('#guardar_iweb_final').prop('disabled', true); //Deshabilito el submit ",
" $('#save_disabled').show(); //Muestro advertencia de completar campos obligatorios ",
" }else{",
"$('#guardar_iweb_final').prop('disabled', false); //Habilito el submit si esta Pendiente",
"$('#guardar_iweb').prop('disabled', false);",
"$('#save_disabled').hide();",
" ",
" } ",
" });"
],
"description": "iw_modificador_script_control_radio_obligatorios"
},
"@a\"..\"" : {
"prefix": "..",
"body": [
"\".$1.\""
]
},
"iw_mascara_definicion_inicial": {
"prefix": "iw_mascara_definicion_inicial",
"body": [
"####################################################################################################",
"## 1) Definición de seguridad, variables del sistema e inclusión de archivos principales",
"if (!preg_match(\"/modules.php/i\",htmlentities(\\$_SERVER['PHP_SELF']))){",
"die (\"You can't access this file directly...\");",
"}",
"require_once(\"mainfile.php\");",
"\\$name = basename(dirname(__FILE__));",
"get_lang(\\$name);",
"",
"\\$sin_marco=\"N\";",
"\\$veo_completo=\"S\";",
"\\$titulo=\"MENU MASCARAS MODELO\";",
"\\$vmh = \"\\$name | \\$file\";",
"\\$vmh_title = \"\\$name | \\$file\"; ",
"",
"# Definición para la nueva versión de iWeb",
"\\$Default_Theme = \"bootstrap\";",
"include(\"header.php\");",
"hash_iweb_header();",
"include (\"includes/fmh.php\");",
"####################################################################################################",
"## 2) Inicio de variables, funciones y JavasScript",
"\\$hoy=date('Y-m-d');",
"\\$ahora=date('Y-m-d H:i');",
"/*\\$searchButton = \"Buscar\";",
"\\$resetButton = \"Reiniciar\";",
"\\$notFoundText = \"\"._NOMATCHES.\"\";",
"if(!isset(\\$pagesize))\\$pagesize=20;*/",
]
},
"iw_mascara_text_input": {
"prefix": "iw_mascara_text_input",
"body": [
"/* Texto simple*/ ",
"echo \"<tr>\";",
"echo \" <td width=\\\"30%\\\">${1:NOMBRE_CAMPO}</td>\";",
"echo \" <td>\";",
"echo \" <div class=\\\"form-inline\\\" id=\\\"tabla_filtros\\\">\";",
"echo iw_dibuja_text(\"sString${2:VARIABLE}\",$$sString${2:VARIABLE}, \"40\", \"40\",$$id=\"\"); ",
"echo \" </div>\\n\";#Cierre Form-inline",
"echo \" </td>\\n\";",
"echo \"</tr>\\n\";"
],
"description": "iw_mascara_text_input"
},
"iw_mascara_lov_modal": {
"prefix": "iw_mascara_lov_modal",
"body": [
"/* LOV */",
"echo \"<tr>\";",
"echo \" <td>${1:NOMBRE_CAMPO}</td>\\n\"; ",
"echo \" <td>\".lov_modal_iweb('${1:NOMBRE_CAMPO}','${2:NOMBRE_TABLA}',$$xform,'${3:NOMBRE_VARIABLE}','${4:id,cod,des}',\"\",$${3:NOMBRE_VARIABLE},\"S\",\"C1,C2,L\",1,\"\",10,\"N\").\"</td>\\n\";",
"echo \"</tr>\\n\";"
],
"description": "iw_mascara_lov_modal"
},
"iw_mascara_lov_modal_filtro": {
"prefix": "iw_mascara_lov_modal_filtro",
"body": [
"/* LOV */",
"echo \"<tr>\";",
"echo \" <td>${1:NOMBRE_CAMPO}</td>\\n\";",
"$$whereFiltro${3:NOMBRE_VARIABLE} = \"${5:(1=(SELECT 1 FROM a0usr_fly_tm_perfil_acceso AS d WHERE d.conjunto_grupo=($$conjunto_connect) AND d.acceso=1) OR f.cod IN(SELECT b.area FROM a0usr_fly_tm_perfil_acceso AS b WHERE b.conjunto_grupo=($$conjunto_connect) AND b.acceso=0))}\"; ",
"echo \" <td>\".lov_modal_iweb('${1:NOMBRE_CAMPO}','${2:NOMBRE_TABLA}',$$xform,'${3:NOMBRE_VARIABLE}','${4:id,cod,des}',$$whereFiltro${3:NOMBRE_VARIABLE},$${3:NOMBRE_VARIABLE},\"S\",\"C1,C2,L\",1,\"\",10,\"N\").\"</td>\\n\";",
"echo \"</tr>\\n\";"
],
"description": "iw_mascara_lov_modal_filtro"
},
"iw_mascara_lov_modal_corto": {
"prefix": "iw_mascara_lov_modal_corto",
"body": [
"/* LOV */",
"echo \"<tr>\";",
"echo \" <td>${1:NOMBRE_CAMPO}</td>\\n\"; ",
"echo \" <td>\".lov_modal_iweb('${1:NOMBRE_CAMPO}','${2:NOMBRE_TABLA}',$$xform,'${3:NOMBRE_VARIABLE}','${4:id,cod,des}',\"\",$${3:NOMBRE_VARIABLE},\"S\",\"C2,L\",1,\"\",10,\"N\").\"</td>\\n\";",
"echo \"</tr>\\n\";"
],
"description": "iw_mascara_lov_modal_corto"
},
"iw_mascara_check_box": {
"prefix": "iw_mascara_check_box",
"body": [
"/* Checkbox */",
"if($${1:VARIABLE}T1==1){",
" $$checked_${1:VARIABLE}T1=\"CHECKED\";",
"}",
"if($${1:VARIABLE}T2==1){",
" $$checked_${1:VARIABLE}T2=\"CHECKED\";",
"}",
"if($${1:VARIABLE}T3==1){",
" $$checked_${1:VARIABLE}T3=\"CHECKED\";",
"}",
"if($${1:VARIABLE}T4==1){",
" $$checked_${1:VARIABLE}T4=\"CHECKED\";",
"}",
"if($${1:VARIABLE}T5==1){",
" $$checked_${1:VARIABLE}T5=\"CHECKED\";",
"}",
"if($${1:VARIABLE}T6==1){",
" $$checked_${1:VARIABLE}T1=\"CHECKED\";",
" $$checked_${1:VARIABLE}T2=\"CHECKED\";",
" $$checked_${1:VARIABLE}T3=\"CHECKED\";",
" $$checked_${1:VARIABLE}T4=\"CHECKED\";",
" $$checked_${1:VARIABLE}T5=\"CHECKED\";",
"}",
"",
"echo \"<tr class=\\\"iweb_filtros_avanzados\\\">\";",
"echo \" <td>${2:NOMBRE_CAMPO}</td>\";",
"echo \" <td>\";",
"echo \" <div class=\\\"form-inline\\\">\";",
"echo iw_dibuja_checkbox(\"${1:VARIABLE}T1\", \"${4:NOMBRE_OP1} \", $$checked_${1:VARIABLE}T1 ,1);",
"echo iw_dibuja_checkbox(\"${1:VARIABLE}T2\", \"${5:NOMBRE_OP2} \", $$checked_${1:VARIABLE}T2 ,1);",
"echo iw_dibuja_checkbox(\"${1:VARIABLE}T3\", \"${6:NOMBRE_OP3} \", $$checked_${1:VARIABLE}T3 ,1);",
"echo iw_dibuja_checkbox(\"${1:VARIABLE}T4\", \"${7:NOMBRE_OP4} \", $$checked_${1:VARIABLE}T4 ,1);",
"echo iw_dibuja_checkbox(\"${1:VARIABLE}T5\", \"${8:NOMBRE_OP5} \", $$checked_${1:VARIABLE}T5 ,1);",
"echo iw_dibuja_checkbox(\"${1:VARIABLE}T6\", \"Todos \", $$checked_${1:VARIABLE}T6 ,1);",
"echo \" </div>\\n\";",
"echo \" </td>\";",
"echo \"</tr>\";"
],
"description": "iw_mascara_check_box"
},
"iw_mascara_radio_button": {
"prefix": "iw_mascara_radio_button",
"body": [
"/* RADIO button */",
"echo \"<tr class=\\\"iweb_filtros_avanzados\\\">\";",
"echo \" <td>${1:NOMBRE_CAMPO}</td>\";",
"echo \" <td>\";",
"echo \" <div class=\\\"form-inline\\\">\";",
"echo iw_dibuja_radio_button(\"${2:radio_button}\", \" ${3:NOMBRE_OP1} \" , \"checked\", \"0\");",
"echo iw_dibuja_radio_button(\"${2:radio_button}\", \" ${4:NOMBRE_OP2}\" , \"\", \"1\");",
"echo iw_dibuja_radio_button(\"${2:radio_button}\", \" ${5:NOMBRE_OP3}\" , \"\", \"2\");",
"echo \" </div>\";",
"echo \" </td>\";",
"echo \"</tr>\";"
],
"description": "iw_mascara_radio_button"
},
"iw_mascara_fecha": {
"prefix": "iw_mascara_fecha",
"body": [
"/* FECHAS */",
"echo \"<tr class=\\\"iweb_filtros_avanzados\\\">\";",
"echo \" <td>${1:NOMBRE_CAMPO}</td>\\n\";",
"echo \" <td>\";",
"echo \" <div class=\\\"form-inline\\\">\\n\";",
"echo \" Desde \". iw_dibuja_fecha(\"${2:NOMBRE_VARIABLE}ini\",$${2:NOMBRE_VARIABLE}ini).\" Hasta \".iw_dibuja_fecha(\"${2:NOMBRE_VARIABLE}fin\",$${2:NOMBRE_VARIABLE}fin);",
"echo \" </div>\";",
"echo \" </td>\\n\";",
"echo \"</tr>\";"
],
"description": "iw_mascara_fecha"
},
"iw_mascara_lista_select": {
"prefix": "iw_mascara_lista_select",
"body": [
"/* LIST */",
"echo \"<tr class=\\\"iweb_filtros_avanzados\\\">\\n\";",
"echo \" <td>${1:NOMBRE_CAMPO}</td>\\n\";",
"echo \" <td>\\n\";",
"echo \" <div class=\\\"form-inline\\\">\\n\"; ",
"echo \" <select name=\\\"${3:VARIABLE_SELECCIONADA}\\\" class=\\\"form-control input-sm\\\">\";",
"foreach($${2:VARIABLE_LISTA} as $$n3 => $$element3) {",
" $$selected = \"\";",
" if ($$n3==$${3:VARIABLE_SELECCIONADA}){",
" $$selected = \"selected\";",
" }",
" echo iw_dibuja_lista($$element3, $$n3, $$selected);",
"}",
"echo \" </select>\"; ",
"echo \" </div>\\n\";",
"echo \"</td>\\n\";",
"echo \"</tr>\\n\";"
],
"description": "iw_mascara_lista_select"
},
"iw_mascara_textarea_popover": {
"prefix": "iw_mascara_textarea_popover",
"body": [
"/* TEXTAREA + POPOVER */",
"echo \"<tr class=\\\"iweb_filtros_avanzados\\\">\";",
"echo \" <td>${1:NOMBRE_CAMPO}</td>\\n\";",
"echo \" <td>\";",
"echo \" <div class=\\\"form-inline\\\">\\n\";",
"echo iw_dibuja_textarea(\"${2:VARIABLE_STR}\",$${2:VARIABLE_STR},\"4\",\"30\");",
"$$contenido_popover${4:IDVARIABLE_POVER} = \"${5:Contenido<br>del<br><b>Popover</b>}\";",
"echo iw_dibuja_popover(\"${3:TITULO_POVER}\",\"${4:IDVARIABLE_POVER}\",$$contenido_popover${4:IDVARIABLE_POVER}, \"S\");",
"echo \" </div>\";",
"echo \" </td>\\n\";",
"echo \"</tr>\";"
],
"description": "iw_mascara_textarea_popover"
},
"iw_mascara_encabezado_datos": {
"prefix": "iw_mascara_encabezado_datos",
"body": [
"/**Encabezado*/",
"echo \"<thead><tr class=\\\"text-center table-iweb-firstrow\\\" >\\n\";",
"iw_sort_url_icon($$sortby, \"uid\", $$sortorder, $$ordenando, $$icon_sort);",
"echo \" <th><a href=\\\"\".hash_iweb_encode_url(\"modules.php?op=modload&name=$$name&file=$$file\".\"$$ordenando\".$$base_link).\"\\\">ID $$icon_sort</a></td>\\n\";",
"iw_sort_url_icon($$sortby, \"name\", $$sortorder, $$ordenando, $$icon_sort);",
"echo \" <th><a href=\\\"\".hash_iweb_encode_url(\"modules.php?op=modload&name=$$name&file=$$file\".\"$$ordenando\".$$base_link).\"\\\">C1 $$icon_sort</a></td>\\n\";",
"echo \" <th>C2</th>\\n\";",
"echo \" <th>C3</th>\\n\";",
"echo \" <th>C4</th>\\n\";",
"echo \" <th>C5</th>\\n\";",
"echo \" <th>C6</th>\\n\";",
"echo \" <th>C7</a></th>\\n\";",
"echo \" <th>C8</th>\\n\";",
"echo \" <th>C9</th>\\n\";",
"echo \" <th>C10</th>\\n\";",
"echo \"</tr></thead>\\n\";",
"/**Fin Encabezado*/"
],
"description": "iw_mascara_encabezado_datos"
},
"iw_mascara_datos_tabla": {
"prefix": "iw_mascara_datos_tabla",
"body": [
"if($$nrows>0) {",
"while($$v = sql_fetch_array($$result, $$dbi)) {",
"echo \"<tr>\\n\";",
"echo \" <td nowrap>\".htmlentities_jbs($$v['uid']).\"</td>\\n\";",
"echo \" <td nowrap>\".htmlentities_jbs($$v['name']).\"</td>\\n\";",
"echo \" <td nowrap>\".htmlentities_jbs($$v['uname']).\"</td>\\n\";",
"echo \" <td>\".htmlentities_jbs($$v['c3']).\"</td>\\n\";",
"echo \" <td>\".htmlentities_jbs($$v['c4']).\"</td>\\n\";",
"echo \" <td>\".htmlentities_jbs($$v['c5']).\"</td>\\n\";",
"echo \" <td>\".htmlentities_jbs($$v['c6']).\"</td>\\n\";",
"echo \" <td>\".htmlentities_jbs($$v['c7']).\"</td>\\n\";",
"echo \" <td><span $$class_textmore>Lorem ipsum dolor sit amet,",
" consectetuer adipiscing elit. Aenean commodo ligula eget dolor. Aenean massa. ",
" Cum sociis natoque penatibus <br />et magnis dis parturient montes, nascetur ridiculus mus.",
" Donec quam felis, ultricies nec, pellentesque eu, pretium quis, sem. Nulla consequat massa quis enim. ",
" Donec pede justo, <br />fringilla vel,<br /> aliquet nec, vulputate eget, arcu. In enim justo, rhoncus ut, imperdiet a, ",
" venenatis vitae, justo. Nullam dictum felis eu pede mollis pretium. Integer tincidunt. Cras dapibus. ",
" Vivamus elementum semper nisi. Aenean vulputate eleifend tellus. Aenean leo ligula, porttitor eu, consequat vitae, ",
" eleifend ac, enim.<br /> Aliquam lorem ante, dapibus in, viverra quis, feugiat a, tellus. Phasellus viverra nulla ut",
" metus varius laoreet. Quisque rutrum. Aenean imperdiet. Etiam ultricies nisi vel augue. Curabitur ullamcorper",
" ultricies nisi. Nam eget dui. Etiam rhoncus. Maecenas tempus, tellus eget condimentum rhoncus, sem quam semper ",
" libero, sit amet<br /><br /> adipiscing sem neque sed ipsum. Nam quam nunc, blandit vel, luctus pulvinar, hendrerit id, l",
" orem. Maecenas nec odio et ante tincidunt tempus. Donec vitae sapien ut libero venenatis faucibus. ",
" Nullam quis ante. Etiam sit amet orci eget eros faucibus tincidunt. Duis leo. Sed fringilla mauris sit amet nibh. ",
" Donec sodales sagittis magna. Sed consequat, leo eget bibendum sodales, augue velit cursus nunc, ",
" </span></td>\\n\";",
"echo \" <td width=\\\"60\\\">\".htmlentities_jbs($$v['c9']).\"</td>\\n\";",
"if ($$v['c10']>0.001){",
"echo \" <td>\".sprintf (\"%.3f\",htmlentities_jbs($$v['c10'])).\"</td>\\n\";",
"}else{",
"echo \" <td>\".sprintf (\"%.3e\",htmlentities_jbs($$v['c10'])).\"</td>\\n\";",
"}",
"echo \"</tr>\\n\";",
"$$x++;",
"}",
"echo \"</table>\";",
"}else{",
"$$colspan = \"11\";",
"echo \"<tr>\";",
"echo \" <td colspan=\\\"$$colspan\\\">$$notFoundText</td>\";",
"echo \"</tr>\";",
"echo \"</table>\";",
"}"
],
"description": "iw_mascara_datos_tabla"
},
"iw_mascara_paginacion": {
"prefix": "iw_mascara_paginacion",
"body": [
"# 7) PAGINACION",
"$$ruta=\"modules.php?op=modload&name=$$name&file=$$file&xmenu=$$xmenu\";",
"paginacionMascara($$ruta,$$min,$$x,$$pagesize);",
],
"description": "iw_mascara_paginacion"
},
"iw_mascara_cierre_mascara": {
"prefix": "iw_mascara_cierre_mascara",
"body": [
"# 8) Cierre de la MASCARA",
"include(\"footer.php\");",
"unset($$veo_completo);",
"echo \"<script>\";",
"echo \" $$('.textmore').readmore({",
" speed: 75,",
" moreLink: '<a href=\\\"#\\\">\"._READMORE.\"</a>',",
" lessLink: '<a href=\\\"#\\\">\"._READLESS.\"</a>'",
" });\";",
"echo \"</script>\"; "
],
"description": "iw_mascara_cierre_mascara"
},
"iw_mascara_OpenDivMascara": {
"prefix": "iw_mascara_opendiv",
"body": [
"openDivMascara();",
]
},
"iw_mascara_closeDivMascara": {
"prefix": "iw_mascara_closeDivMascara",
"body": [
"closeDivMascara();",
]
},
"iw_mascara_OpenDivMascaraAmplio": {
"prefix": "iw_mascara_OpenDivMascaraAmplio",
"body": [
"OpenDivMascaraAmplio();"
],
"description": "iw_mascara_OpenDivMascaraAmplio"
},
"iw_mascara_CloseDivMascaraAmplio": {
"prefix": "iw_mascara_CloseDivMascaraAmplio",
"body": [
"CloseDivMascaraAmplio();"
],
"description": "iw_mascara_CloseDivMascaraAmplio"
},
"iw_mascara_modal": {
"prefix": "iw_mascara_modal",
"body": [
"/* MODAL */",
"echo \"<tr>\";",
"echo \" <td>${1:NOMBRE_CAMPO}\";",
"echo \" </td>\";",
"echo \" <td>\";",
"echo \" <i class=\\\"fa fa-eye fa-lg\\\" aria-hidden=\\\"true\\\" data-html=\\\"true\\\" data-toggle=\\\"modal\\\" data-target=\\\"#${2:VARIABLEMODAL}\\\"></i>\";",
"iw_dibuja_modal(\"<b>${3:TITULO_MODAL}</b>\", \"${4:CONTENIDO_MODAL}\", \"${2:VARIABLEMODAL}\",\"<input type=\\\"submit\\\" name=\\\"buscar\\\" value=\\\"$searchButton\\\" class=\\\"btn btn-default btn-sm\\\">\",\"sm\");",
"echo \" </td>\";",
"echo \"</tr>\";"
],
"description": "iw_mascara_modal"
},
"iw_modificador_mails_jbs": {
"prefix": "iw_modificador_mails_jbs",
"body": [
"#################################################################################",
"### RUTINA DE COMUNICACION",
"#################################################################################",
"$$subject = \"[iWeb] Asunto del mensaje - Nro. Registro: $$clave\";",
"$$mensaje_comunicado .= \"<br /><b>Nro Registro.: </b>$$clave\\n\";",
"$$mensaje_comunicado .= \"<b>Observación: </b>\".$$v['observacion'].\"\\n\"; ## Contenido del mensaje",
"## Ejemplo de reemplazo de campos del formulario en una variable string",
"$$subject=\"Usted tiene un no conformidad de la maquina: |id_maquina \";",
"$$subject_nuevo=Carga_Datos_Text($$id_form,$$v,$$subject,'|');",
"",
"if($$mensaje_comunicado != \"\"){",
"### Encabezado de Comunicación con html",
"$$headers = array();",
"$$headers[] = \"MIME-Version: 1.0\";",
"$$headers[] = \"Content-type: text/html; charset=iso-8859-1\\r\\n\";",
"//$$headers[] = \"Content-type: text/plain; charset=iso-8859-1\";",
"$$headers[] = \"From: $$nom <$$connect_email>\";",
"//$$headers[] = \"Cc: Sistema iWeb <mail@hola.com>,Sistema iWeb <otromail@hola.com>\";",
"$$headers=implode(\"\\r\\n\", $$headers);",
"",
"$$encabezado = $$sitename;",
"$$titulo = \"iWorkflow | Tickets\";",
"$$href = \"$$nukeurl/modules.php?name=sgc_registracion&file=genera2&registro=$$clave&do=presentaform2&id_form=$$id_form&xmenu=$$xmenu\";",
"$$link = hash_iweb_encode_url($$href);",
"$$descripcion_link = \"Link al registro\";",
"$$footer = \"Recuerde estar logueado en previamente en iWeb\";",
"$$texto_alternativo = \"J&B Solutions\";",
"",
"$$content = iweb_mail_template($$encabezado,$$titulo,$$mensaje_comunicado,$$link,$$descripcion_link,$$footer,$$texto_alternativo);",
"}",
"",
"",
"## Por vector con ids_usuarios de sistema",
"if($$mensaje_comunicado != '' AND count($$usuarios_comunicar) > 0){",
"echo \"<b>Comunicación programada:</b><br />\";",
"if(count($$usuarios_comunicar) > 0){",
"foreach($$usuarios_comunicar as $$n3 => $$element3) {",
"## ver si el usuario está habilitado con user_viewemail",
"$$sql_usr=\"select email, name FROM \"._IW_USERS.\" WHERE uid = '$$element3' AND user_viewemail=0\";",
"$$res_usr = sql_query($$sql_usr,$$dbi);",
"list($$mail,$$name)=sql_fetch_row($$res_usr,$$rdbi);",
"if($$mail!= \"\"){",
"if(mail_jbs($$mail,$$subject,$$content,$$headers)){",
"$$mensaje2=\"<IMG SRC=\\\"images/sgc/f_poll.gif\\\" BORDER=\\\"0\\\" alt=\\\"Enviado\\\">\";",
"echo \"<IMG SRC=\\\"images/sgc/f_poll.gif\\\" BORDER=\\\"0\\\" alt=\\\"Enviado\\\">\\n\";",
"echo \"$$mail<br>\";",
"}",
"## Acá podemos auditar en notas anexas las comunicaciones realizadas.",
"}",
"}",
"}",
"}",
"## Por vector con mails",
"if($$mensaje_comunicado != '' AND count($$array_mail) > 0){",
"echo \"<b>Comunicación programada:</b><br />\";",
"if(count($$array_mail) > 0){",
"foreach($$array_mail as $$n3 => $$element3) {",
"$$mail = $$element3;",
"if($$mail!= \"\"){",
"if(mail_jbs($$mail,$$subject,$$content,$$headers)){",
"$$mensaje2=\"<IMG SRC=\\\"images/sgc/f_poll.gif\\\" BORDER=\\\"0\\\" alt=\\\"Enviado\\\">\";",
"echo \"<IMG SRC=\\\"images/sgc/f_poll.gif\\\" BORDER=\\\"0\\\" alt=\\\"Enviado\\\">\\n\";",
"echo \"$$mail<br>\";",
"}",
"## Acá podemos auditar en notas anexas las comunicaciones realizadas.",
"}",
"}",
"}",
"}",
"## Por grupo funcional",
"if($$mensaje_comunicado != '' AND $$grupo_comunica!=\"\"){",
"",
"$$select_usr_gf = \"SELECT a.uid as uid, a.email as email",
"FROM \"._IW_USERS.\" a",
"INNER JOIN \"._IW_SGC_CONJ_GRUPOS.\" b",
"ON a.conjfun = b.id_conjunto",
"WHERE b.id_grupo = (SELECT id_grupo FROM \"._IW_SGC_GRUPOSF.\" WHERE cod_grupo = '$$grupo_comunica')\";",
"$$res_usr_gf = sql_query($$select_usr_gf,$$dbi);",
"while($$v_usr_gf = sql_fetch_array($$res_usr_gf,$$dbi)){",
"$$usuarios_comunicar_grf[$$v_usr_gf['uid']] = $$v_usr_gf['email'];",
"}",
"echo \"<br><b>Comunicación programada a grupo funcional $$grupo_comunica:</b><br>\";",
"if(count($$usuarios_comunicar_grf) > 0){",
"foreach($$usuarios_comunicar_grf as $$n3 => $$element3) {",
"$$mail=$$element3;",
"if($$mail!= \"\"){",
"if(mail_jbs($$mail,$$subject,$$content,$$headers)){",
"$$mensaje2=\"<IMG SRC=\\\"images/sgc/f_poll.gif\\\" BORDER=\\\"0\\\" alt=\\\"Enviado\\\">\";",
"echo \"<IMG SRC=\\\"images/sgc/f_poll.gif\\\" BORDER=\\\"0\\\" alt=\\\"Enviado\\\">\\n\";",
"echo \"$$mail<br>\";",
"}",
"}",
"## Acá podemos auditar en notas anexas las comunicaciones realizadas.",
"}",
"}",
"}"
],
"description": "iw_modificador_mails_jbs"
},
}